========================================================================= Date: Sun, 1 Aug 1993 15:53:16 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Richard Brown (dickb)" Subject: Re: Microsoft and the Internet Nathan, In case this hasn't been cleared up: It's ACCBUG -- no hyphen. By the way, in a previous career I worked as a newspaper reporter. My first job was in Logansport. I used to drive over to Purdue to hang around the campus and feel like I was in a real city. Dick Brown Access Editing Manager ---------- From: Nathan Brindle To: Multiple recipients of list ACCESS-L Subject: Microsoft and the Internet Date: Tuesday, July 27, 1993 9:05AM This was posted some time back, but not everyone may have a copy or remember it (I know didn't...). To report bugs in Access: Send mail to ACCBUG@MICROSOFT.COM To send in your wishes for upcoming versions: ACC-WISH@MICROSOFT.COM One caveat--I think I remember the ACCBUG address as ACC-BUG (with the hyphen) but I didn't see it that way in the list archives. So if ACCBUG doesn't work, try ACC-BUG. Or maybe someone has a hard copy of Microsoft's letter that announced this handy? BTW, as I told Phil Paxton, I agree with him that the record counting problem is unlikely to be a bug. Since Access does not provide an implicit recordcounting function, you're flirting with disaster :) when you try to write one in Access Basic. "That's not a bug--it's a !" What interest me, however, is the fact that in Professional Basic 7.1 you can query an ISAM file via the LOF() function and get the number of records returned to you. Why can't we do that in Access? Or am I completely confused? (Which would NOT surprise me...) -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Sun, 1 Aug 1993 21:09:32 -0400 Reply-To: Eugene Levine Sender: Microsoft Access Database Discussion List From: Eugene Levine Subject: Re: Microsoft and the Internet In-Reply-To: <199308012256.AA03943@world.std.com> Does anyone know how the Microsoft email address system works? I have some questions/ requests/ suggestions about non Access applications, and about he interface between them and Access. Thanks in advance, Gene elevine@world.std.com ========================================================================= Date: Mon, 2 Aug 1993 07:14:27 +0000 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Marty McMahon Subject: GRAPHS IN ACCESS To: I'm relatively new to the use of ACCESS. Is there a good book that explains how to build and modify graphs using ACCESS? Does it make more sense to export to Excel and make them there? marty.mcmahon@kauai.ds.boeing.com ========================================================================= Date: Mon, 2 Aug 1993 10:29:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: MKRO Subject: Text Box Input Editing As Data is Entered Would like to know if anyone has a thought/created a way to edit or format the input(value) of a text box as it is being entered by a user? I have a text box that is bound to a date field on a table. I would like to be able to format the text in the text box as it is entered, so that the user would see a "/" as they type a date value. EXAMPLE: User types 01 then a "/" is shown automatically by my logic User continues to type 05 then another "/" appears in the text box and then the User completes the date entry with 93. What this amounts to is dynamic data editting or formating. Is there a way to do this with the format property? Or can it be accomplished in a function()? Any suggestions or ideas? Thanks in advance. Mike Kroeger ========================================================================= Date: Mon, 2 Aug 1993 16:37:00 GMT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: CHEN Hi all, I'm trying to format a report printout to page break only at the end of a record. Is there a way to do this? Will I need to write a macro or module? Thanks advance for your help! Susan Chen Dialog Information Services, Inc. CDROM Division chen@dialogvm.mcimail ========================================================================= Date: Mon, 2 Aug 1993 12:03:29 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Louis M. Swiczewicz" Subject: Soccer Roster via Report Wizard Dear Access-L members: I have the responsibility for managing my town's youth soccer league. To date, there are 32 teams distributed across four age divisions. Each team has two coaches and at least 12 players. The information for coaches is included in a table named "Coaches Fall'93." The data for players is located in a table named "House League F'93." The common link between these two tables is the field entitled "Team ID." I am attempting to generate a report (i.e., Roster) for each team. I would like the names of the coaches to appear at the top of the report and the players' information to appear in the body of the report. I know that it is possible to create a report which contains subreports using report wizard. However, my attempts to incorporate subreports has not been very successful. Instead of getting individual team rosters, the output is one report which groups all players and coaches. Does anyone know if it is possible to design a report using report wizard that will give me 32 individual reports (rosters) which will include the names for both players and coaches by team? I have just recently started dabbling in Access basic so I am not sure if the results I desire can be best achieved via that methodology. I will appreciate all assistance. Thank you. Lou Swiczewicz Swicz@ACC.RWU.EDU ========================================================================= Date: Mon, 2 Aug 1993 12:06:33 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Help on setting number of copies to print Help! "I've got a little macro..." Well, the point is, I'm trying to use an InputBox to get how many copies of a report the user wants to print. It seems to work fine (including the Access Basic code) until the value is input and the macro tries to use the value returned by the function. The interesting part is that I get a BLANK error message from Access when this point is reached (a message box with an exclamation point but NO MESSAGE). So I don't see where the problem is. Has anyone got a code example to show me how to do this? I'm scratching my head, (not pulling out my hair--what hair?), wondering. Thanks, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 2 Aug 1993 13:58:10 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: copies to print--figured a dodge I figured out how to specify the number of copies of the report I wanted. I just wrote it in Access Basic and forgot the macro (except to call the function). This procedure feels kludgy to me and it seems like it would be nice if the OpenReport method in immediate print mode had a number of copies argument. Of course, that might make calling the other modes kind of weird. The code fragment: Function QLCopies() Response = InputBox("How many copies to print?", "QuickList", "1") If Response = "" then Exit Function DoCmd SelectObject A_REPORT, "QuickList", True DoCmd Print , , , , Response DoCmd Minimize QLCopies = Response End Function That's probably a mess (and QLCopies() is a dummy function anyway), but for this particular program the Database window is minimized--thus the DoCmd Minimize at the end to put it back where it belongs. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 2 Aug 1993 11:25:43 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Dmitry Serebrennikov Subject: Re: Text Box Data Editing as Data is Entered > > Would like to know if anyone has a thought/created a way to edit or format > the input(value) of a text > box as it is being entered by a user? I have a text box that is bound to a > date field on a table. I would > like to be able to format the text in the text box as it is entered, so that > the user would see a "/" as they > type a date value. EXAMPLE: User types 01 then a "/" is shown > automatically by my logic User continues to type 05 then another "/" appears > in the text box and then the User completes the date entry with 93. > > What this amounts to is dynamic data editting or formating. Is there a way > to do this with the format property? Or can it be accomplished in a > function()? Any suggestions or ideas? > > Thanks in advance. > Mike Kroeger > According to MicroSoft there is no way to do this that in Access now. The only alternative is to use AfterUpdate function to read the value and reformat it to your liking and then put it back in the control. It works, but only after user has left the field, not while typing. There are talks about allowing to use VBX controls in Access and other MS apps, but that is all not in the near future. ========================================================================= Date: Mon, 2 Aug 1993 11:06:48 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Dmitry Serebrennikov Subject: Re: Access Basic In-Reply-To: <199307301603.AA25681@hp4at.eunet.co.at> from "Dave Stultz" at Jul 30, 93 09:02:38 am I think this is mostely right, but: > Function MoreButton() > Docmd Hourglass True > Docmd Echo False > Docmd Setwarnings False ******************* > Dim Curr as Form > Dim F as String > Set Curr=Screen.Activeform.Name > Set F=Forms![Curr] ******************* The piece in *** is the problem. The correct thing to use in the expressions below in place of F is a variable of type Form. So if you have Dim F as Form Set F=Screen.ActiveForm it should do the trick. Notice that it is just "Screen.ActiveForm" that returns the current form Object. Screen.ActiveForm.FormName returns the name of the form (a string). You could use that to get a hold of the form Object, but it is a round-about way of doing it. Also, as other people have mentioned you have to reset Echo to On in Access Basic code manualy while in macros that is done for you when the macro ends. Also you can not hide of disable a control that has the focus. But you knew that didn't you... > F!Titles.Visible=False > F!Titles.Enabled=False > F!Moretitles.Visible=True > F!Moretitles.Enabled=True > F!More.Visible=False > F!More.Enabled=False > Good luck. Dmitry. dmitry@ucsee.berkeley.edu ========================================================================= Date: Mon, 2 Aug 1993 21:50:14 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Richard Moldwin Has anybody tried the new Sheriden Data Controls for VB 3.0? There is a fully functional spreadsheet control that seems to emulate the Access Datasheet. There are also controls to fill in most of the missing datacontrols in VB. If I only knew how to transport my access form designs into VB! Has anybody written a utility to do this yet? Transporting code is easy, but the forms are another story.:-) --Rich Moldwin ========================================================================= Date: Mon, 2 Aug 1993 23:50:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: RH Subject: Memo Field Text Formatting I have an application that requires more text formatting capability within a MEMO field then than appears to be available with Access (i.e. CNTRL ENTER and SPACE). Is there a third party add-in for Access which provides features like variable margins, hanging indents, bullets, and multiple fonts for MEMO fields? I would prefer not to link or imbed objects from other apps like WORD just to get the enhanced formatting. Any ideas? Thanks in advance, Bob Hanschke Texas Instruments, Inc. Dallas, TX ========================================================================= Date: Tue, 3 Aug 1993 08:17:37 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: STAUFFER_ERIC_B@LILLY.COM Subject: signoff From: STAUFFER ERIC B IVM1 1 RM66696 Subject: ACCESS-L@INDYCMS.BITNET To: INTERNET ADDRESS BITN ========================================================================= Date: Tue, 3 Aug 1993 12:19:39 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Shannon Burgin <##06@UTMARTN.BITNET> Subject: Re: Access Speed? In-Reply-To: In reply to your message of THU 22 JUL 1993 14:49:59 EDT > > I have just recently purchased Access 1.0 (and have upgraded to 1.1), and I > > have been having some problems with speed. I have a 386-DX/33 Mhz with 4 Me > > of RAM, and in Windows I'm running a 6 Meg permanent swapdrive with 32-bit > > access. I am trying to write a database for a baseball card collection, and > > every single action I make takes at least a few seconds, if not longer. I > > have attached buttons to macros which run queries, and when I run them, the > > hourglass icon appears for up to thirty seconds. Is there anything I can do > > to speed this harrowing process up? > > Dave Stultz > > STULTZ@DENISON.EDU > > > > p.s. > > I don't have a math co-processor - could having one make that much of > >a difference? > > > Dave, the rule of thumb I've heard circulated the most (and endorsed by > Microsoft) is adding 4Mg of memory > to a 386 (that already has 4Mg -- for a total of 8M) will increase Access > performance significantly more than > migrating to a 486 that only has 4Mg. > > > Phil Paxton > Development Editor, eidetic, and 7-ball juggler > SAMS/Prentice Hall Computer Publishing > Carmel, Indiana My 386 Model/70 only had 4 meg when I began using Access. I have since added 8 meg more for reasons other than speeding up Access, but the side benefit is a significant improvement to Access. ************************************************************************ * * * * Shannon Burgin * University of Tennessee/Martin * * Bitnet: ##06@UTMARTN.BITNET * Computer Center * * Phone: 901-587-7890 * 102 Cooper Hall * * Senior Systems Analyst * Martin, TN 38238 * * VM/VSE/CICS/VSAM/DLI/SQLDS * * ************************************************************************ ========================================================================= Date: Tue, 3 Aug 1993 10:44:15 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Deleting records and warnings I previously posted how I figured out how to use macros to delete the record currently displayed on a form. Well, something funny happened. I wasn't using SetWarnings to turn off the messages, because I happen to like being asked if I'm sure or not. Works real great in the first form I did this in. I went to implement this in another form I have, and lo and behold, it doesn't give me a warning! It simply deletes the record. Well, I figured, maybe the SetWarnings flag was off for some reason, so I included an explicit SetWarnings Yes action in the macro, but it still won't warn me. What might be different between the two forms or underlying queries to cause the different results? Both forms are based on queries. Any ideas? -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Wed, 4 Aug 1993 09:20:25 +0200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "M. Ederveen" Subject: Ole object test Hello all! It could be I previously posted this, but I never saw any reactions and the problem is still there: When fine-tuning the application I made with Access the following problem occurred: I'm using a picture (OLE-object) of a persons' autograph in the database. The picture is supposed to be scanned and Pasted into the form. I created a custom menu bar with the Paste function added. This works fine. Only thing is: I'd like to protect the picture from being overwritten by mistake. So I tried using the ISNULL function in the same macro that activates the Paste function in the custom menu bar. This works but not good: the check is made properly but then the Paste function cannot be activated anymore. Also the field property of an OLE-object doesn't have features like ON-ENTER and ON-UPDATE, so how can I do this? Greetings, Martin. ------------------------------------------------------------------------------- | ing. Martin W. Ederveen | "In the future there will be real | | Hogeschool Eindhoven | thinking machines. | | Rachelsmolen 1 | Yes, but who's thoughts will they | | 5612 MA Eindhoven | be thinking?" | | tel. +31 (40) 605 262 | | | MARTIN@HSEPM1.HSE.NL | Quotation from Dr.Who: The Curse | | SURF017@KUB.NL | of Fenric | ------------------------------------------------------------------------------- ========================================================================= Date: Thu, 5 Aug 1993 10:40:05 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Dmitry Serebrennikov Subject: Re: Ole object test In-Reply-To: <199308040722.AA20813@hp4at.eunet.co.at> from "M. Ederveen" at Aug 4, 93 09:20:25 am > > Hello all! > > It could be I previously posted this, but I never saw any reactions and the > problem is still there: > > When fine-tuning the application I made with Access the following > problem occurred: > > I'm using a picture (OLE-object) of a persons' autograph in the database. > The picture is supposed to be scanned and Pasted into the form. > I created a custom menu bar with the Paste function added. > This works fine. > Only thing is: I'd like to protect the picture from being overwritten by > mistake. So I tried using the ISNULL function in the same macro that > activates the Paste function in the custom menu bar. This works but not > good: the check is made properly but then the Paste function cannot be > activated anymore. Also the field property of an OLE-object doesn't have > features like ON-ENTER and ON-UPDATE, so how can I do this? > > Greetings, > > > Martin. > I am not sure I understand the problem... If you could be more specific on how you are using ISNull and why doesn't it work the secod time? Did you try to step through the macro? What happens? Does ISNull think that the field is not null even though it is?.. As a Bubble-Gum (tm) solution you can keep another field around with a flag weither the picture is posted or not... ========================================================================= Date: Fri, 6 Aug 1993 09:50:27 MEZ Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Erich Neuwirth Subject: Re: ACCESS-L Digest - 4 Aug 1993 to 5 Aug 1993 In-Reply-To: Message of Thu, 5 Aug 1993 23:00:04 -0500 from i just got my software upgrade for access (1.1) there is an offer in ther for the documetation for $ 49.50 having the printed docs for 1.0, is it worthwhilw buying the updated documentation? any recommendations? ERICH NEUWIRTH BITNET (EARN): A4422DAB@AWIUNI11 INTERNET: a4422DAB@vm.univie.ac.at = 131.130.1.2 Institute for Statistics, Operations Research, and Computer Methods UNIVERSITY OF VIENNA, UNIVERSITAETSSTR. 5/9, A-1010 VIENNA, AUSTRIA TEL.: +43-1-40407-160 FAX: +43-1-40407-88 ========================================================================= Date: Fri, 6 Aug 1993 08:55:33 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: MJY0000 Subject: Erratic Screens I'd like to find out if anybody else is experiencing this problem: When I'm in Design mode (whether it's a Form, Query, Table, etc.) I will sometimes experience my screen or parts of my screen changing to a larger font and usually changing to Bold also. It doesn't seem to affect what's actually in my Access DB because when I switch over to a "Run mode" everything appears okay. I cannot figure out the pattern, if there is one, or what is causing this. It is rather erratic because sometimes if I just click on the screen it will go back to how it should be. Very strange. I have not changed video divers or anything like that. I was experiencing this problem before I upgraded to Access 1.1 and was sort of holding out hoping the upgrade would "fix" the problem. Also I am only experiencing this problem with Access. I use other Apps such as Quicken, MS Word and Micrografx Designer with no problem. This doesn't appear to be a devastating problem. It is something I can live with - its just very annoying. If anybody else is experiencing a similar problem or if someone has a suggestion, I'd appreciate hearing from you. _\\|//_ 0 0 --------------uuu---U---uuu----------------------------------------- - Mike Yurche - Phone (410) 780-6589 - - Computer Services - Fax (410) 574-2172 - - Essex Community College - - - Baltimore, MD 21237 - BITNET MJY0@ECC - -------------------------------------------------------------------- Opportunities are never lost - they're simply found by someone else! ========================================================================= Date: Fri, 6 Aug 1993 08:09:52 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Steve Bratten Subject: Messed up screens in Design Mode... >I'd like to find out if anybody else is experiencing this problem: > >When I'm in Design mode (whether it's a Form, Query, Table, etc.) >I will sometimes experience my screen or parts of my screen changing >to a larger font and usually changing to Bold also. It doesn't I have experienced this on several occasions but, just as the author of the original message, I haven't recognized a pattern or found a solution. ^^^^^^^^^Steve Bratten^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | _ o__ | | ( \ _/_ _.>/^_ BITNET < GE0793@SIUCVMB > | | \ / _ _ _ (_) \(_) INTERNET < GE0793@SIUCVMB.SIU.EDU > | | \_) (__(/_/(_/\_(/_ | | __ \o \o \o Graduate School | | |__) __ __ -/-/-_ __ |> |> |> Southern Illinois University | | |__) / (_(_/(_/`/_(/_/// < \ < \ < \ Carbondale, IL 62901-4716 | | | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^ ========================================================================= Date: Fri, 6 Aug 1993 09:11:04 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: George Waller Subject: Is Access 1.1 FTP available? Is Access 1.1 available for FTP and if not, could someone make it available? My understanding is that there is no licensing problem with doing so. ========================================================================= Date: Fri, 6 Aug 1993 10:35:35 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: ? How to copy (backup) an .mdb In trying to apply the KISS principle to the application I'm writing for my supervisor :), I have run up against a slight problem. I need to assign some code to a command button that will copy the entire .MDB file to the A: drive for the purpose of making an archival backup. I realize she could do this by going to the File Manager and dragging and dropping the file to A:, but she's used to the kludge I whipped up in dBase that performed this operation. Am I going to run up against sharing violations when I try to copy the (open) .MDB to disk? Something tells me that I will. Should I shell out to the File Manager (as demonstrated using the Calculator in the Shell section of the Language Reference) to accomplish this feat? Or should I just forget it and tell her to use the File Manager? :) Thanks for any advice. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Fri, 6 Aug 1993 10:52:05 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "ROBERT GRINNELL, SEATTLE PACIFIC UNIVERSITY" Subject: Re: ACCESS-L Digest - 4 Aug 1993 to 5 Aug 1993 On Fri, 6 Aug 1993 09:50:27 MEZ, Erich Neuwirth writes: >i just got my software upgrade for access (1.1) >there is an offer in ther for the documetation for $ 49.50 >having the printed docs for 1.0, >is it worthwhilw buying the updated documentation? >any recommendations? This was a concern of mine, too, until the upgrade arrived. After reviewing the What's New in Version 1.10 help file (MSA110.HLP), I concluded that none of the changes was of a type that would alter the documentation substantially or pervasively. They are all pretty distinct and self-contained. The help file tells you all you need. Robert Grinnell Seattle Pacific University r_grinnell@luke.spu.edu ========================================================================= Date: Fri, 6 Aug 1993 11:44:03 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "ROBERT GRINNELL, SEATTLE PACIFIC UNIVERSITY" Subject: Re: ? How to copy (backup) an .mdb On Fri, 6 Aug 1993 10:35:35 EST, Nathan Brindle writes: >In trying to apply the KISS principle to the application I'm writing for >my supervisor :), I have run up against a slight problem. I need to >assign some code to a command button that will copy the entire .MDB file >to the A: drive for the purpose of making an archival backup. I realize >she could do this by going to the File Manager and dragging and dropping >the file to A:, but she's used to the kludge I whipped up in dBase that >performed this operation. >Am I going to run up against sharing violations when I try to copy the >(open) .MDB to disk? Something tells me that I will. >Should I shell out to the File Manager (as demonstrated using the Calculator >in the Shell section of the Language Reference) to accomplish this feat? >Or should I just forget it and tell her to use the File Manager? :) My guess (and I am operating at the edges of my knowledge here) is that your only chance of doing this with the .MDB open is to make a WinAPI call from within the database to do the copying. Anything else would hit a share violation, since the file in question is registered to Access in Share's system. But having not tried it, I sure can't guarantee the WinAPI call would work, either. Guess that's for you to find out. I'd like to know if it works, it could be a very useful general purpose function. Robert Grinnell Seattle Pacific University r_grinnell@luke.spu.edu ========================================================================= Date: Fri, 6 Aug 1993 21:08:28 +0200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "M. Ederveen" Subject: Re: Erratic Screens I do not experience your change-screen fonts problem. There could be something wrong within Windows, fonts tend to be thrown around in the memory a lot, maybe some problem there? Also you might be running some virus, other resident program or faulty mouse-driver? Martin Ederveen ========================================================================= Date: Fri, 6 Aug 1993 16:14:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: MKRO Subject: I/O with Barcodes for MS Access Has anyone come across any information about using I/O from a barcode reader to supply data for MS Access forms and controls? I have APP that manages inventory, it sure would be slick if I could scan information in and out, updating tables and screens! ========================================================================= Date: Fri, 6 Aug 1993 16:41:19 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: ? How to copy (backup) an .mdb In-Reply-To: Message of Fri, 6 Aug 1993 11:44:03 PDT from One thing that came to mind on this question was to create an empty .mdb on the backup floppy and use TransferDatabase or CopyObject to move each object, one at a time, to the backup .mdb. This strikes me as a losing kludge (worse than the one I wrote in dBase to do the same thing), and it seems to me that MS needs to give us a BackupDatabase command in the next version. Being LANless and essentially backupless here in academia :), I've got to think of SOMETHING. Like I say, however, I'll probably end up telling my supervisor to use the File Manager and move the file manually to floppy. Merry Weekend....:) -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Fri, 6 Aug 1993 14:53:20 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Re: I/O with Barcodes for MS Access In-Reply-To: <9308062123.AA02326@hermes.intel.com>; from "MKRO" at Aug 6, 93 4:14 pm > Has anyone come across any information about using I/O from a barcode reader > to supply data for > MS Access forms and controls? I have APP that manages inventory, it sure > would be slick if I could > scan information in and out, updating tables and screens! There are a number of things you can do with scanners and a database application, and they all apply to Access. The first I can think of is real-time data entry, kind of like scanning groceries or something. With this, if the data entry point is fixed (a cash register or something), you can actually connect a scanner to the PC in-between the keyboard and the PC. Then, the scanner and decoder send input to the PC as if it had been entered by the keyboard. The other major thing is data collection. Like, if you conducting an inventory of a warehouse or something. Here you will want a portable data collection scanner unit. It may be something simple, or sophisticated. In either case, all you need is a common data format, which is usually something as simple as a common delimited text file. If you want to check the inventory as you scan, you'll need to dump the data from Access to the scanner via this text file, and then conduct your inventory with the scanner. Or, you may want to just go scan barcodes, and then dump the data from the scanner to Access using a text file, and then let Access reconcile it. I will be using Access to do a combination of all three within a few weeks. We're going to upload a large database of information to a high-end portable scanner, which will then be used to conduct audits or inventories of equipment, but also provide more information, like where the equipment is at, who is using it, and so forth, all of which can be checked while doing the invetory/audit. Then, we'll make corrections in real-time using keyboard input to the scanner, and when all done, upload those corrections back to the database in Access. We already do something similar in dBase, but it will be no different with Access. You just write some AccessBasic code to pull in the data from the text file (which, if the format is right, can be done with just a couple lines of code), and then process that data. Of course, we're paying big money to the company which is programming the scanner so that it can handle its end of the job. And of course, we'll also be linking Access with another piece of software which will print barcodes on a thermal barcode printer. It should all be in place in about 3 weeks (although it took twice as long to develop the specifications for the whole system). -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Fri, 6 Aug 1993 14:54:42 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Re: I/O with Barcodes for MS Access In-Reply-To: <9308062123.AA02326@hermes.intel.com>; from "MKRO" at Aug 6, 93 4:14 pm Forgot something. For uploading/downloading large amounts of information, you can use a standard telecommunications program like ProComm, which you can also automate to do the whole job automatically. This way you don't worry about the I/O within Access, just the delimited text files. -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Sat, 7 Aug 1993 15:08:11 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Steve Miller Organization: PictureTel Corporation Subject: Access Utility Uploaded to CICA I just uploaded a utility to ftp.cica.indiana.edu that I downloaded from Compuserve. Here is part of the description file: Description =========== Access Spell-Rite is an add-in module that you can use to help with spelling of object names, field names, and control names. It lists every object in your database, including field names, control names, and macro group names. You can have it copy any of these names to the clipboard, adding square brackets [] if necessary. It is then a simple procedure to paste the name where it is required. Access Event-Finder is an add-in module that you can use to help locate events on a form or report, so you can track down odd behaviour caused by macros and modules. -- +-------------------------------------------------------+ | Steve Miller PictureTel Corporation | | email: miller@pictel.com One Corporation Way | | phone: (508) 977-8235 Peabody, MA 01960 | +-------------------------------------------------------+ ========================================================================= Date: Sat, 7 Aug 1993 14:46:20 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Linda D. Cornell" Subject: 2 Questions I need to pass the data entered in one field to a query used to generate a combo box for the next field. For example, in field 1 the user selects code 1 (from a combo box). I need to pass code 1 to the query that generate the combo box for field 2. I wrote a parameter query that works fine until I put it into the form. Does anyone have any advice? Also, has anyone been successful updating a field based upon data entered into a previous field? For example, field 2 is updated based upon the data entered into field 1. Thanks. Rochelle Cole (who is helping Linda Cornell and using her account) Thanks from me too! Linda Cornell lcornell@u.washington.edu ========================================================================= Date: Sun, 8 Aug 1993 11:28:07 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Richard Moldwin Subject: Re: Erratic Screens In-Reply-To: Your message of Fri, 6 Aug 1993 08:55:33 EDT Mike, I'm having the exact same problem with screen fonts. I'm using a Gateway 486DX2/50 with 8MB RAM and an ATI-Ultra (not local bus). What's your configuration? ---Rich Moldwin ========================================================================= Date: Sun, 8 Aug 1993 21:17:21 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Bill Stewart Subject: Access Tip I just got done figuring out how to make the toolbar reappear after turning it off through a macro (and using a custom menu bar on a form). I was trying to use the sendkeys command and it wasn't working. Apparently if the menu bar of the form you're working on doesn't have the menu item to select it can't be choosen. The work around (via the PIM example) is to select the Database window by using the select object command in the same macro as the send keys command. My rational that this works is that you have to select an object or form that has the menu item you want to select. ------------------------------------------------------ Bill Stewart Gendale Community College 6000 W. Olive Ave Glendale AZ. 85302 ------------------------------------------------------ ========================================================================= Date: Mon, 9 Aug 1993 09:49:41 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Access Tip In-Reply-To: Message of Sun, 8 Aug 1993 21:17:21 -0700 from That's the same workaround that I doped out last Thursday to do the exact same thing. Minds must be working in parallel on this list...:) My macro (part of the CloseProject macro that runs when I hit the Exit button in my main form) looks like this: SendKeys Keystrokes: {TAB}{TAB}{TAB}YES{ENTER} Wait: No DoMenuItem Menu Bar: Database Menu Name: View Command: Options Somewhere I read that it is mandatory to do the SendKeys you execute the command they belong to. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 9 Aug 1993 10:35:06 EDT Reply-To: arbert@aol.com Sender: Microsoft Access Database Discussion List From: Brett Archer Subject: Re: ? How to copy (backup) an... Have you tried to use the TransferDatabase "command" to backup a database? ========================================================================= Date: Mon, 9 Aug 1993 07:29:33 +0000 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Marty McMahon Subject: GRAPHS IN ACCESS 'm relatively new to the use of ACCESS. Is there a good book that explains how to build and modify graphs using ACCESS? Does it make more sense to export to Excel and make them there? marty.mcmahon@kauai.ds.boeing.com ========================================================================= Date: Mon, 9 Aug 1993 11:38:03 -0600 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Tim Mackay Subject: PageMaker -> RTF -> Access I've been assigned with a special project that requires me to get data from Aldus PageMaker into Microsoft Access. The data consists of PartNumbers, Descriptions, Notes, and Prices for parts, and the parts fall into a series of Categories. The PageMaker data isn't tabular, but the fields are formatted in different ways on different lines. I understand that PageMaker will export RTF - ascii text with embedded formatting commands - and that Access will import ascii text, so I figure that RTF is a good intermediary step. Once I have an RTF file, I'll parse the RTF with Access, putting underlined lines into the Categories field, bold lines into the Description fields, italic lines into the Notes field, etc. Sound dooable? My question is: Is there an RTF specification available anywhere on the 'net so I can better understand how to read RTF files' embedded commands? or Where can I learn more about RTF files and how they're formatted. or Is there an easier way to do this? Thanks in advance for any help. Tim Mackay |paper-net:Marquette Electronics, Inc internet: tmackay@mei.com | 8200 W Tower Ave voice-net:(414) 362-2765 | Milwaukee, WI 53223 ========================================================================= Date: Mon, 9 Aug 1993 11:51:04 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: PageMaker -> RTF -> Access In-Reply-To: Message of Mon, 9 Aug 1993 11:38:03 -0600 from Since there's no PageMaker filter for Access, I'd be inclined to put the data into tabular form, create the corresponding table in Access, and cut and paste. I don't know if this will work but I'm going to play with it here in a minute and see. If it's possible to export from PM into dBase IV, I'd be more inclined to go that route and then import the resulting .dbf into Access. Again, I don't know if the dBase IV filter is two-way or just one-way in Pagemaker. Access import RTF? That's news to me if so. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 9 Aug 1993 11:58:57 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: PageMaker -> RTF -> Access In-Reply-To: Message of Mon, 9 Aug 1993 11:38:03 -0600 from I misunderstood what you were going after. For some reason I read you as saying you wanted to export data from PM. You can indeed Paste Append tabular data copied to the clipboard from PM into Access. Whether your other idea (export to RTF then import and parse in Access) would work is something I can't answer. Sorry if I confused the issue. Can you work with a copy of the PM file and put the data into tabular form? If the file isn't too big and you aren't talking about too many records, that seems like the easiest thing to do. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 9 Aug 1993 13:54:36 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Phillip (Phil) Paxton" <72410.2162@COMPUSERVE.COM> Subject: PageMaker -> RTF -> Access % I've been assigned with a special project that requires me to get data from % Aldus PageMaker into Microsoft Access. The data consists of PartNumbers, % Descriptions, Notes, and Prices for parts, and the parts fall into a series % of Categories. The PageMaker data isn't tabular, but the fields are % formatted in different ways on different lines. % I understand that PageMaker will export RTF - ascii text with embedded % formatting commands - and that Access will import ascii text, so I figure % that RTF is a good intermediary step. Once I have an RTF file, I'll parse % the RTF with Access, putting underlined lines into the Categories field, % bold lines into the Description fields, italic lines into the Notes field, % etc. Sound dooable? I'll play techno-cynic for a moment -- just be prepared to do some handholding -- it never fails when migrating data from a free format arena to a structured arena. A good example of this type of problem comes when people use things like Excel (I'm not picking on Microsoft, Lotus123, Quattro Pro, etc. can be substituted) as a database then realize they need to "move up" to a real database system and suddenly find they have to define their fields as long text strings or memo fields because so many exceptions to the [data] rules suddenly appear. I've seen a lot of this over time and received a lot of phone calls in the last year or so from friends and former co-workers who are in the process of migrating just such a situation -- suddenly the "this is the name field" becomes "well, it's the name field for everyone else, but since we didn't know his real name, we put this here..." (you can imagine how the rest of the conversation went). I guess what I'm trying to say is: don't be surprised if you suddenly find not all bold is a description, or that all descriptions aren't necessarily bold, etc. etc. -- and the best part is, it'll run smoothly until you are busy on ten other projects and suddenly someone of Dutch extraction decides to throw their wooden shoes into the fray... P.S. On a lighter note, keep us posted -- it sounds like an interesting project. (Good Luck) Phil Paxton Development Editor SAMS/Prentice Hall Computer Publishing Carmel, Indiana ========================================================================= Date: Mon, 9 Aug 1993 13:08:00 -0600 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Tim Mackay Subject: Re: PageMaker -> RTF -> Access >Can you work with a copy of the PM file >and put the data into tabular form? If the file isn't too big and you >aren't talking about too many records, that seems like the easiest thing >to do. The file is HUMUNGOUS, and that's why I'm even considering this kind of work. Tim Mackay |paper-net:Marquette Electronics, Inc internet: tmackay@mei.com | 8200 W Tower Ave voice-net:(414) 362-2765 | Milwaukee, WI 53223 ========================================================================= Date: Mon, 9 Aug 1993 12:00:39 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "ROBERT GRINNELL, SEATTLE PACIFIC UNIVERSITY" Subject: Re: GRAPHS IN ACCESS On Mon, 9 Aug 1993 07:29:33 +0000 Marty McMahon writes: >'m relatively new to the use of ACCESS. Is there a good book that explains >how to build and modify graphs using ACCESS? Does it make more sense to >export to Excel and make them there? Don't know about books. As for Excel vs. Graph, I'd recommend using Graph for anything that you are going to use over again. If you just want a one-time graph and are more adept with Excel than Graph, then you would probably want to just copy the data over to Excel and go from there. Robert Grinnell Seattle Pacific University r_grinnell@luke.spu.edu ========================================================================= Date: Mon, 9 Aug 1993 21:13:59 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Bill Stewart Subject: Re: GRAPHS IN ACCESS From the little bit of expirence I've had with graphs I've found that the power is within the query. It took me awhile to create the query that would generate the graph I wanted. To me it sounds like it would be easier to generate a graph in excel, but I'm going to make the be of MS graph. I have a budget database that has the ability to show a bar graph of the spending by department. Kind of slick. I really hate the idea of the users of this database having to generate a report in excel format than launch excel to see the chart. Good luck! ------------------------------------------------------ Bill Stewart Gendale Community College 6000 W. Olive Ave Glendale AZ. 85302 ------------------------------------------------------ ========================================================================= Date: Tue, 10 Aug 1993 08:42:49 CST Reply-To: jao9w265@aurora.cdev.com Sender: Microsoft Access Database Discussion List From: "John A. Olson" Subject: How do we run .exe, .bat etc. from within A. B. Hello, It's been a long time since I sat down and sent something to this list. I am trying to write a function in Access Basic which at one point needs to run a MSDOS batch file before continuing on. My problem is that although I can use the SHELL command to start the batch file running, the Access Basic code continues running before tha batch file even executes. This is unsatisfactory. How can I write some code to cause the execution of the function to halt temporarily until the batch file has completed its course of action? The Shell function is found in the language reference and looks like this: x = Shell("xxxx.bat" , 5) where the number indicates the type of window to run the executable file in. HELP! I have a deadline on this project and I need some good advice quickly. Thank You. John Olson Computing Devices International f.k.a. Control Data Corporation ========================================================================= Date: Tue, 10 Aug 1993 15:59:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: MKRO Subject: Printing "Form Letters" Searching for design ideas/experience with printing "form" letters in MS ACCESS. Would like to take a preformatted text letter, pull name and address information from an access table while in an MS ACCESS application, and print the letter. Also be able to give the users a way to edit the preformatted text letter. ANY SUGGESTIONS? I have been contemplating exports to MS WORD, POKES to a WORD document, hardcoding the text in an ACCESS Basic module...Ect. Is there a cleaner way? ========================================================================= Date: Tue, 10 Aug 1993 18:12:19 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Phillip (Phil) Paxton" <72410.2162@COMPUSERVE.COM> Subject: Printing "Form Letters" % Searching for design ideas/experience with printing "form" letters in MS % ACCESS. % Would like to take a preformatted text letter, pull name and address % information from an access table while in an MS ACCESS application, and print % the letter. Also be able to give the users a way to edit the % preformatted text letter. ANY SUGGESTIONS? I have been contemplating % exports to MS WORD, POKES to a WORD document, hardcoding the text in an % ACCESS Basic module...Ect. Is there a % cleaner way? When you say "POKE", you mean DDE POKE, right? (Not the old PC-BASIC POKE) Take a look at 1.1 -- when you export a table, one of the options is "Word for Windows Merge". (I think that'll solve your problem) Phil Paxton Development Editor SAMS/Prentice Hall Computer Publishing Carmel, Indiana ========================================================================= Date: Wed, 11 Aug 1993 16:47:39 +1000 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Doan Subject: Help with calling functions in user-defined DLL from Access Basic? Hello, Is it possible to call functions in user-defined DLL ? I have followed examples from Intro to Programming and use the Declare statement and all that but when I tried call functions in my own DLL I get an error message which says "Duplicate procedure name" I suppose I could use the windows API to call the functions in my DLL but perhaps someone can show me a better way of doing this. Thanks. David Doan ========================================================================= Date: Wed, 11 Aug 1993 16:08:27 GMT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Richard Saunders, Computer Centre" Organization: University Of East London Subject: Multiple copies of mailing label Hi! I am a new user of Microsoft Access, and hence of this discussion list. I have created a names and addresses table to use for mailing labels but I can't work out how to print multiple copies of a single label. I don't want to use the Copies option of the Windows Print Manager because that prints each label on a new page. Ideally I would like to add a "Number of copies" field to the table (from 0 to 999, say) and have Access print labels for the whole table based on that field. Any tips would be appreciated. Thanks. ========================================================================= Date: Wed, 11 Aug 1993 10:33:14 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Multiple copies of mailing label In-Reply-To: Message of Wed, 11 Aug 1993 16:08:27 GMT from The answer is: FTP the file ACC-KB.EXE from FTP.CICA.INDIANA.EDU (or its mirrors) where it is still sitting in /pub/pc/win3/uploads/JUN93. ACC-KB.EXE is a self-extracting archive of the ACC-KB.HLP file which is the Access Knowledge Base. One of the articles in the Knowledge Base addresses the issue of making multiple copies of the same label. Alternately, if you have no FTP access but can handle a UUencoded file and know how to use the LISTSERV file archive commands, it is available from LISTSERV@INDYCMS in four pieces. Send the command IND ACCESS-L to LISTSERV@INDYCMS to obtain a filelist to get the exact names (my memory doesn't extend that far...sorry!). HTH -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 11 Aug 1993 10:34:27 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: schuck@SFU.CA Subject: Re: Multiple copies of mailing label In-Reply-To: <9308111635.AA11348@whistler.sfu.ca>; from "Richard Saunders, Computer Centre" at Aug 11, 93 4:08 pm > > Hi! I am a new user of Microsoft Access, and hence of this discussion > list. I have created a names and addresses table to use for > mailing labels but I can't work out how to print multiple copies of a > single label. I don't want to use the Copies option of the Windows > Print Manager because that prints each label on a new page. > > Ideally I would like to add a "Number of copies" field to the table > (from 0 to 999, say) and have Access print labels for the whole table > based on that field. > > Any tips would be appreciated. Thanks. > Off the top of my head, I can think of a quick and dirty method for a reasonable number of copies ie 1 - 10. Create a copy table with 1 field [No of copies] There would be 1 record with a 1, 2 records with a 2 , etc ie: 1 2 2 3 3 3 4 4 4 4 Base your label printing on a query that joins the [No of copies] on your address table to the no_of_copies table. A 3 copies record would appear 3 times in the query. This method would work without using Access Basic. ========================================================================= Date: Wed, 11 Aug 1993 14:41:01 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Variables in sql statements in basic I think this has been discussed before perhaps, but I haven't had the time to read the list much lately. I'm going to be doing some CreateDynaset operations in AccessBASIC soon, and will be basing them off of SQL statements. My experience with AccessBASIC thus far is that almost every operation has its own expression-building/syntax quirks. Before I get into it, what is the best way basing that SQL statement on data in a variable? In other words, I need the WHERE clause to be flexible. Can someone give me an example of how they do this? I may find it is simple enough, but experience tells me I'm going to waste time if I don't just ask first. Thanks in advance. -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Fri, 13 Aug 1993 09:23:00 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Skewes-Cox, Tom" Subject: Moving to beginning of Tab order I am trying to write a generic navigation macro for data entry/edit forms that will move to the next record and place the focus on the first control in the tab order. I am trying to avoid having to create a form specific GoToControl command for each form. Is there a macro command that can do this or do I need to get into Basic. If I do need to use Basic how do you access the tab order of a form? *-------------------------------*-----------------------------------* * Tom Skewes-Cox * * * Research Associate * Phone : (310) 206-8470 * * Student Affairs Information * * * and Research Office * E-Mail: tskewes@saonet.ucla.edu * * 274 Kinsey Hall * * * Los Angeles, CA 90024-1324 * Fax : (310) 206-2978 * * UCLA Mail Code: 132405 * * *-------------------------------*-----------------------------------* ========================================================================= Date: Sat, 14 Aug 1993 16:42:21 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Linda D. Cornell" Subject: Need help with a surly subform Hi there, Has anyone out there managed to create a form that has a command button which opens a subform? We can get a subform to work just fine imbedded in the parent form, however, it really slows down the performance of the parent form, and the subform information isn't always needed. We just want to be able to call it when we want it! If we use the button we made to just open a regular form, we get all the records in the table associated with that secondary form, rather than just the records that would be chosen with a subform. We've tried using the macro behind the button to link the key information from the record on the main form to a secondary form's data file, but we can't get that to cooperate either. What are we doing wrong - are we just coming at this wrong? Any help will be appreciated. Thanks in advance for any assistance! Linda Cornell lcornell@u.washington.edu UW Office of Research ========================================================================= Date: Sun, 15 Aug 1993 00:36:26 -0700 Reply-To: Kristina Sontag Sender: Microsoft Access Database Discussion List From: Kristina Sontag Subject: Re: your mail In-Reply-To: <199308021701.AA17200@halcyon.com> If I understand the question correctly, the simple way to do this (force page breaks to only happen after a record, not in the middle of one) is to set the section property "Keep Together" to yes. That, in fact, is the only way I do it. You may have to play around with your report format slightly to avoid too much blank space at the bottom of the page, but this property will eliminate the problem of records being split across two pages. I hope that helped! --kris --airplane@halcyon.com ========================================================================= Date: Mon, 16 Aug 1993 10:24:09 +0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Chan Chor Ling Subject: Re: need help with a surly subform Dear Linda, Try to make use of the Where Conditions in your macro to open the subform. eg. When U press the command button, it will execute the macro, OpenSubForm Macro - Openform Form Name : SubformName View : Form Where : [SubformControlName] = Forms![MainFormName]![MainFormControlName] .... If U don't know what I mean, please read Page 535 of Microsoft Access User's Guide. Chor Ling ========================================================================= Date: Mon, 16 Aug 1993 10:30:08 +0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Chan Chor Ling Subject: Microsoft Access Analyser I tried to analyse my table using Microsoft Access Runcode - StartAnalyzer(). I discovered that there is some discrepancies. One of my field which is not indexed has an indexname after I analyse the table. Has anyone encountered something like this before ? How do U overcome it ? Chor Ling NCLCHAN@NTUVAX.NTU.AC.SG ========================================================================= Date: Mon, 16 Aug 1993 10:31:57 +0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: NCLCHAN@NTUVAX.BITNET Subject: Re: Analyzer Dear Nathan, I am so sorry. Please ignore my letter Analyzer. I make a mistake. The IndexName Reference 2 indicates foreign key rather than indexName, if I am not mistake n this time. Please delete my letter. Chor Ling NCLCHAN@NTUVAX.NTU.AC.SG ========================================================================= Date: Mon, 16 Aug 1993 15:02:00 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Briganti, Joe" Subject: Problem reading Pdox file from Access Help. I've been trying to read a Paradox file from my Access db but keep getting asked for its password. I've believe I have removed all security passwords from the Paradox end but to no avail. Anybody out there fluent in Access and Paradox able to help me? I'm using Access 1.1 and Paradox 1.0 (for Windows). I'm trying to attch to the sample Paradox table called biolife (found in diveplan I think!) -- Joe Briganti ( j.briganti@trl.oz.au) ========================================================================= Date: Mon, 16 Aug 1993 16:58:10 +1000 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Graeme Burton Subject: Re: ACCESS-L Digest - 13 Aug 1993 to 14 Aug 1993 have the join field in both forms. The macro called when you press the button will open the second form - use the where box to ensure that the join fields are the same. Cheers. =============================================================================== Graeme Burton | | Student Systems Manager| | Phone: (07) 875 7500 Griffith University | email: G.Burton@gu.edu.au | Nathan 4111 | | Fax: (07) 875 7957 Australia | | =============================================================================== ========================================================================= Date: Mon, 16 Aug 1993 13:23:23 GMT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Richard Saunders, Computer Centre" Organization: University Of East London Subject: Multiple copies of labels > > Off the top of my head, I can think of a quick and dirty method for a > reasonable number of copies ie 1 - 10. > > Create a copy table with 1 field [No of copies] > > There would be 1 record with a 1, 2 records with a 2 , etc > > ie: > > 1 > 2 > 2 > 3 > 3 > 3 > 4 > 4 > 4 > 4 > > Base your label printing on a query that joins the [No of copies] on > your address table to the no_of_copies table. > > A 3 copies record would appear 3 times in the query. > > > This method would work without using Access Basic. Thanks for this suggestion and to Nathan Brindle for indicating the article "Skip Used Mailing Labels and Printing Duplicate Labels" in the Knowledge Base, which I have now read. In the end I decided to keep things simple and base my printing on a parameter query. First I created a table with a single field containing values from 0 to 999. (I set this up as a counter type field and made it the primary key, but both these steps are optional - I think.) Then I created a query to choose the labels(s) I want to print. Finally I created a parameter query based on the above table and query (not joined). I added the counter field to the QBE grid but turned off its "Show" checkmark, then added the criterion < [How many copies do you want?] to this field. Now when I run my parameter query it asks "How many copies do you want?" If I enter say, 50, it creates a dataset with 50 duplicates of my chosen label(s), corresponding to counter fields 0 to 49. I included a SORT in my parameter query so that if I am choosing more than one label, the labels for each record are printed in separate blocks, instead of alternating. I think all I need to do now is base my mailing labels report on this parameter query. ========================================================================= Date: Mon, 16 Aug 1993 10:22:41 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Analyzer In-Reply-To: Message of Mon, 16 Aug 1993 10:31:57 +0800 from Oh well, we all make mistakes...especially me. :) Unfortunately, once you send it, it's sent...this isn't an edited list. So don't worry about it... ncb -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 16 Aug 1993 11:37:05 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Greg Fairnak Organization: The American University Subject: Re: Microsoft Access Analyser In-Reply-To: Message of Mon, 16 Aug 1993 10:30:08 +0800 from Which version of Access are you running? 1.0 or 1.1 ========================================================================= Date: Mon, 16 Aug 1993 08:42:32 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jim Renaud Subject: Re: Problem reading Pdox file from Access > > Help. > > I've been trying to read a Paradox file from my Access db but keep getting > asked for its password. I've believe I have removed all security passwords > from the Paradox end but to no avail. > > Anybody out there fluent in Access and Paradox able to help me? > > I'm using Access 1.1 and Paradox 1.0 (for Windows). I'm trying to attch to > the sample > Paradox table called biolife (found in diveplan I think!) > -- > Joe Briganti ( j.briganti@trl.oz.au) > The problem is that Borland changed the format of it's database (incompatible) from 3.5 to 4.0. As far as I know, Access only supports the 3.5 version of Paradox for now. Paradox for Windows uses the new 4.0 engine. I'm not a Paradox expert, but I think it would work if you could export your Paradox for Windows database to a Paradox 3.5 engine format. ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Mon, 16 Aug 1993 13:47:15 -0600 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Tim Mackay Subject: Re: How do we run .exe, .bat etc. from within A. B. jao9w265@aurora.cdev.com writes: >I am trying to write a function in Access Basic which at one point needs >to run a MSDOS batch file before continuing on. My problem is that although >I can use the SHELL command to start the batch file running, the Access >Basic code continues running before tha batch file even executes. This >is unsatisfactory. How can I write some code to cause the execution of the >function to halt temporarily until the batch file has completed its course >of action? > >The Shell function is found in the language reference and looks like this: > > x = Shell("xxxx.bat" , 5) > >where the number indicates the type of window to run the executable file in. Here's how I'd try to do it. Mind you, I haven't tried this yet, so it might not work. In the last line of your batch file, have it make a dummy file: dir > c:\dummy.txt In Access Basic, right after you shell to your batch file, write a Do Until...Loop that does a directory and checks for the existence of the dummy file. When it finds the dummy file, you know that the batch file is done processing. Continue with your code after the dummy is found, and delete dummy.txt when your function is done (or maybe wait a little longer to avoid sharing violations). Hope this helps. Tim Mackay |paper-net:Marquette Electronics, Inc internet: tmackay@mei.com | 8200 W Tower Ave voice-net:(414) 362-2765 | Milwaukee, WI 53223 ========================================================================= Date: Mon, 16 Aug 1993 14:22:33 -0600 Reply-To: jao9w265@aurora.cdev.com Sender: Microsoft Access Database Discussion List From: "John A. Olson" Subject: Re: running .bat from Access In message Mon, 16 Aug 1993 01:36:13 -0700 (PDT), dmitry@ucsee.Berkeley.EDU (Dmitry Serebrennikov) writes: > Hello, > this is got to be the most awful and horrible solution the you'll get, > but... If you are using .bat files about the only thing they can do is to > create files, right, so you can test in access basic for existence of a > file by trying to open it using Open command (just a generic DOS file open > thing) and doing errorhandling appropriately. I told you it was awful! > Well, come to think of it, you could use environment variables, I think I > saw somewhere in access something like GetEvironment or the like. That > would be even slick (comparing to the previous idea) uh. > > Good luck. > Dmitry@ucsee.berkeley.edu > Thank you for responding. I did manage to find a very effective way to accomplish this feat. It involves using a Windows API function named GetModuleUsage. The correct declaration and syntax follow for anyone who may be interested in doing the same thing I needed to do. In the Declarations section of your Access Basic module, enter the following line: Declare Function GetModuleUsage% Lib "Kernel" (ByVal hProgram%) Then, in whatever function is shelling out to run a Dos Executable program, use the following code to cause the function to "wait" until that DOS program has run its course: x = Shell([Executable filename], 6) 'The 6 is insignificant, check the book. While GetModuleUsage(x) DoEvents Wend The real key here is that while the executable is still running, GetModuleUsage returns a value of True. Once it has finished running, GetModuleUsage returns False and your Access Basic function can exit the While Loop and continue on its merry way. The DoEvents command lets the computer continue running other tasks even though the function appears to be in an infinite loop. I Hope this proves useful to others as well. Regards, John A. Olson Computing Devices International jao9w265@aurora.cdev.com ========================================================================= Date: Mon, 16 Aug 1993 12:58:00 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Morris Myers Subject: Re: Problem reading Pdox file from Access > Help. > > I've been trying to read a Paradox file from my Access db but keep getting > asked for its password. I've believe I have removed all security passwords > from the Paradox end but to no avail. > > Anybody out there fluent in Access and Paradox able to help me? > Access cannot read Paradox 4.0 tables. If you want to read Paradox 4.0 tables (same database engine as Pdox for Windows) from Access you must convert them to 3.5 format. I am not sure you can do that with Pdox for Windows (I gave up on Pdox for Windows when Access became available). You can perform that conversion feat with Pdox 4.0 for DOS. > I'm using Access 1.1 and Paradox 1.0 (for Windows). I'm trying to attch to > the sample > Paradox table called biolife (found in diveplan I think!) > -- > Joe Briganti ( j.briganti@trl.oz.au) > -- ----------------------------------------------------------------------- Morris Myers [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-746-4798 Bldg. M3 Room 311 Fax: 408-629-4374 1230 E. Arques Avenue Email: xrysta@mcode.amdahl.com Sunnyvale, CA 94088-3470 or: morris@xrysta.birdsong.suvl.ca.us ========================================================================= Date: Mon, 16 Aug 1993 13:43:42 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Dmitry Serebrennikov Subject: Transactions and forms. Well, it's my time to ask questions. I have been experimenting with Transactions in Forms and didn't get much luck with them. Specifically I have a form that provides an access to customer accounts (doesn't really make a difference but for the sake of example...) So I want to have the form in read only mode until the Edit button is pressed. Then I AllowEditing and continue until they press Save. I got that to work, butI also wanted to start a transaction when Edit is pressed and Commit it when Save is pressed (so I could also make Undo button). Now the form has a few subforms. Do you know if one transaction will handle many tables? In my experiments I got confused in how to handle leaving the current record (between OnCurrent and OnAfterUpdate properties). And also the rollback didn't seem to roll anything back... It is very possible that I am missing something obvious. Could someone who had experience with this kind of thing shed some light on how they've implemented similar situation. Tankx in advance. dmitry@ucsee.berkeley.edu ========================================================================= Date: Mon, 16 Aug 1993 13:51:24 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Re: Transactions and forms. In-Reply-To: <9308162046.AA00542@hermes.intel.com>; from "Dmitry Serebrennikov" at Aug 16, 93 1:43 pm Dmitry, I'm sure someone will correct me if I am wrong, but I believe that the manuals state that the transaction features of Access are _not_ applicable to forms, but rather only to processing done in AccessBasic. This is something of a major drawback, but it wouldn't be the first. The only way I know to get true transaction processing is to handle everything manually, which means nothing but unbound fields and a lot of code. I truly hope someone can provide you with a better way. -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Mon, 16 Aug 1993 16:55:55 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: George Waller Subject: Fields as rows How can I get fields to appear as rows? Say a survey was done and respondents answer each question with a value from 1 to 9. Total Average Question1 22 3.7 Question2 33 3.2 Question3 32 3.8 And, if that's not enough, how could "non-answers" be handled so that averages would be correct. (Not all respondents answered the question). Thanks! ------------------------------------------------------------------------ George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS University of Connecticut, Storrs CT 06269-1005 203-486-5260 Internet: hbladm47@uconnvm.uconn.edu Bitnet: HBLADM47@UCONNVM.BITNET ------------------------------------------------------------------------ ========================================================================= Date: Tue, 17 Aug 1993 17:22:32 +0800 Reply-To: paul@sqltech.DIALix.oz.au Sender: Microsoft Access Database Discussion List From: Paul Templeman Organization: Sequel Technology Subject: MS Access and Btrieve files I suspect I'm asking a common question, but here goes anyway. I've got a Btrieve based accounting system that I am using and am trying to access the data via Access. However the file extensions are *.btr and MS-Access is looking for files with the extension *.ddf. I believe that the .ddf files are data definition files which tells Access the format etc. of the *.btr files, as the structure is not kept in the *.btr files. Am I on the right track here ? If so my question is can someone tell me how to create the *.ddf files. Is there a utility to do this available via ftp or from the list server. Any help much appreciated. Paul... -- Paul Templeman Sequel Technology Phone : +61 9 417 5713 Technical Director 16 Bloodwood Circle Fax : +61 9 417 7413 paul@sqltech.DIALix.oz.au South Lake 6164 Pager : +61 9 483 5822 Western Australia ========================================================================= Date: Tue, 17 Aug 1993 08:34:05 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: SQL question I'm developing an app in VB 3.0 (nice environment, BTW, but kind of quirky when you're used to Access--the properties menu doesn't stay on top, for one thing, and that's kind of a hassle--also the properties menu doesn't quite work the same way --but anyway, my SQL question is: I'm trying to write a Search pop-up in VB that duplicates the Search popup in Access. Did fine designing it, it works perfectly-- except that I don't know how to add in the functions for Match Case and Search All Fields. I've been digging through the Microsoft SQL section in the Access Language Reference but the documentation is kind of skimpy. The Find* methods don't include this sort of functionality and that's what I'm sort of stuck with at the moment. Any thoughts? Actually I have a glimmer of an idea on the Search All Fields but I shudder at writing the code...and I'd like it to be more flexible than my idea would allow it to be. TIA, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Tue, 17 Aug 1993 13:10:52 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Donn C Young Subject: Re: ACCESS-L Digest - 15 Aug 1993 to 16 Aug 1993 In-Reply-To: <199308170401.AA10930@hp4at.eunet.co.at> > Date: Mon, 16 Aug 1993 16:55:55 EST > From: George Waller > Subject: Fields as rows > > How can I get fields to appear as rows? Say a survey was done > and respondents answer each question with a value from 1 to 9. > > Total Average > Question1 22 3.7 > Question2 33 3.2 > Question3 32 3.8 > > And, if that's not enough, how could "non-answers" be handled so > that averages would be correct. (Not all respondents answered the > question). > > Thanks! > George, It kinda depends on how your table is defined. If it looks like: Respondent#, Q1resp, Q2resp, Q3resp, Q4resp, ... You can get the answers you need by just doing a Select Query and specifying Q1resp(avg), Q1resp(sum), Q1resp(count), Q2resp(avg),... in the QBE grid. This doesn't 'rotate' the table to give you columns as rows, but it gives you the answers nonetheless. Note, too, that the avg [noted in the QBE Total row] and other calculated values are based on non-null entries; if someone fails to answer, their non-response isn't used in calculating an average - unless of course you specified a default entry of 0 for that numeric field. Now, if your table is defined as: Respondent#, Question#, Response You can generate the answer by doing a Select Query with: Field: Question# Response Response Response Total: Group By Sum Avg Count Sort: Ascending That should give you a columns as rows result. Donn Young, OSU Cancer Center Biostatistics Unit dyoung@magnus.acs.ohio-state.edu ========================================================================= Date: Tue, 17 Aug 1993 14:07:17 -0600 Reply-To: jao9w265@aurora.cdev.com Sender: Microsoft Access Database Discussion List From: "John A. Olson" In message Tue, 17 Aug 1993 17:22:32 +0800, Paul Templeman writes: > I suspect I'm asking a common question, but here goes anyway. > I've got a Btrieve based accounting system that I am using > and am trying to access the data via Access. However the > file extensions are *.btr and MS-Access is looking for files > with the extension *.ddf. I believe that the .ddf files are > data definition files which tells Access the format etc. of > the *.btr files, as the structure is not kept in the *.btr > files. Am I on the right track here ? If so my question is > can someone tell me how to create the *.ddf files. Is there > a utility to do this available via ftp or from the list server. > > Any help much appreciated. > > Paul... > > -- > Paul Templeman Sequel Technology Phone : +61 9 417 5713 > Technical Director 16 Bloodwood Circle Fax : +61 9 417 7413 > paul@sqltech.DIALix.oz.au South Lake 6164 Pager : +61 9 483 5822 > Western Australia > Yes there is a utility for this. I'm not sure what it costs but I used the copy my company had to accomplish much the same feat as you have described. The .ddf file is indeed the data dictionary file which describes the structure of the btrieve table(s). What you need to create is the file named file.ddf which may already exist somewhere within your btrieve system. If not, what I used was the btrieve command butil -stat [fileneme] to give me an idea of what the indexes were and then I used Xtrieve to create the dictionary definition file. I'm not sure this helps you any, but I hope it will. Good Luck! John A. Olson Computing Devices International jao@aurora.cdev.com ========================================================================= Date: Tue, 17 Aug 1993 21:42:43 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: tegulesseria@URSINUS.BITNET Subject: Re: ACCESS-L Digest - 11 Aug 1993 to 13 Aug 1993 If I understand it correctly, your problem comes from having too many wind ows open at the same time. The parent form o nce the daughter form is opened any problems doin g this and the speed reduction was minimal. Oh and the way any problems doin ========================================================================= Date: Wed, 18 Aug 1993 06:55:00 GMT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Clare Love <0005794946@MCIMAIL.COM> Subject: PDS What is it? Can anyone tell me something about PDS 7.1? I assume it is some form of database oriented development system. Please contact me directly. Clare Love 579-4946@MCIMail.com 621 M St. Voice (206) 533-3484 Hoquiam WA 98550 ========================================================================= Date: Wed, 18 Aug 1993 11:10:55 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: John Daum at 6-6835 or 618-632-2456 Subject: DBMS Magazines In-Reply-To: <9308180702.AA18238@tiberius.safb.af.mil> Does anyone have a recommendation for a good, well rounded magazine for databases? The perfect one would cover the popular PC DBs (Paradox, Access, Foxpro, DBase) as well as the server DBMSs (Oracle, Sybase, Interbase) and the challenges of standardizing, connecting, and communicating among them all. Thanks, John Daum daumj@tiberius.safb.af.mil ========================================================================= Date: Wed, 18 Aug 1993 10:04:10 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Morris Myers Subject: Re: DBMS Magazines > Does anyone have a recommendation for a good, well rounded magazine for > databases? The perfect one would cover the popular PC DBs (Paradox, > Access, Foxpro, DBase) as well as the server DBMSs (Oracle, Sybase, > Interbase) and the challenges of standardizing, connecting, and > communicating among them all. > > Thanks, > John Daum > daumj@tiberius.safb.af.mil > My guess is that almost everybody will have a recommendation ({->). I subscribe to several db mags - DBMS, Database Advisor, Access Advisor, Database and Paradox Informant. All have good points. The one that covers the broadest base of RDBMSs is Database Advisor. Obviously, Access Advisor covers Access in more detail as does Paradox Informant for Paradox. Database and DBMS also cover a broad range of RDBMSs I just happen to like the depth and style of the articles in Database Advisor. HTH g.mo -- ----------------------------------------------------------------------- Morris Myers [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-746-4798 Bldg. M3 Room 311 Fax: 408-629-4374 1230 E. Arques Avenue Email: xrysta@mcode.amdahl.com Sunnyvale, CA 94088-3470 or: morris@xrysta.birdsong.suvl.ca.us ========================================================================= Date: Wed, 18 Aug 1993 12:44:45 -0600 Reply-To: Karen McMains Sender: Microsoft Access Database Discussion List From: Karen McMains Subject: Duplicate record checking in Access In-Reply-To: <9308181706.AA05078@henson.cc.wwu.edu> Our Admissions Office hopes to use Access for our simple, but quite large, name-and-address database of prospective students. We receive students' names from multiple sources (phone calls, letters inquiring about our school, college fairs, students who send us SAT/ACT scores, etc.). In most cases we do not get their SSN, and so we have no unique identifier. We're still using 'sneaker-net', so we must keep the central database on one PC, enter records to diskette using many different PCs, then import the daily entries to the central database at the end of each day and check for duplicate records. Since we have no unique identifier we use the student's name plus address and/or birthdate, depending on what data we have on that student. Of course, students often give us slightly different versions of their names and addresses, i.e. Susie Smith, Susan Smith, S. Smith, which makes duplicate checking even more challenging. Since we mail thousands of recruiting pieces to these students, we must check for duplicates to reduce costs. We have been using PCFile5.01 for this database (groan!), and duplicate checking was about the ONLY part of the application that worked well under PCFile. Dup checking was a specific function and we could specify the fields, say, last name and the first three letters of the first name. Then PCFile would display the 'duplicates' side by side and prompt for which record, if any, we wished to delete. Seeing the records displayed side by side made it easy to determine if 'Susie Smith' was the same person as 'Susan Smith'. We don't have access to programmers, and my sophomore MIS student and myself have been unable to find a good solution to dup checking with Access, even after calls to Microsoft. Currently she's set up a duplicate check using the July 1993 Smart Access tips, with the queries working on last name concatenated with first name, but this will miss many duplicates because first names won't always match, and there's no easy way to see which records Access is designating as duplicates. Can anyone suggest a workaround in Access? Alternately, can anyone suggest databases that would meet our needs for dup checking? We like most other features of Access and need to use the Windows environment. THANKS!!!!! Karen McMains Sr. Asst. Dir./Systems & Operations Admissions/Western Washington University Bellingham, WA 98225-9009 mcmains@henson.cc.wwu.edu ========================================================================= Date: Wed, 18 Aug 1993 16:25:09 MDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List Comments: Converted from PROFS to RFC822 format by PUMP V2.1 From: DAVIDB Subject: Locating Duplicates Question: Is there any way to have ACCESS find duplicate keys for me and then show then to me on the screen? I am trying to clean up my tables that I have imported from an Excell spreadsheet and I have problems. Any help would be appreciated. Thanks in advance. David L. Baudais, C.E.T. | Domain: DAVIDB@NAITVM.NAIT.AB.CA Information Systems Division | "A Live mind can see a window" CO-OP Student | "onto a world of possibilities." N.A.I.T. | PS: I have tried to use a query but I am not sure how to do it. ========================================================================= Date: Wed, 18 Aug 1993 16:18:11 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: schuck@SFU.CA Subject: Re: Locating Duplicates In-Reply-To: <9308182302.AA23494@whistler.sfu.ca>; from "DAVIDB" at Aug 18, 93 4:25 pm > > Question: Is there any way to have ACCESS find duplicate keys for me and then > show then to me on the screen? I am trying to clean up my tables that I have > imported from an Excell spreadsheet and I have problems. Any help would be > appreciated. Thanks in advance. > > David L. Baudais, C.E.T. | Domain: DAVIDB@NAITVM.NAIT.AB.CA > Information Systems Division | "A Live mind can see a window" > CO-OP Student | "onto a world of possibilities." > N.A.I.T. | > > PS: I have tried to use a query but I am not sure how to do it. > One solution: 1) Add a counter field on your table. Call it key1 say. This gives you a unique key. 2) In the query, choose your table twice. 3) Link with the key you wish to check. 4) Add any fields you need to see, plus the key1 fields from both. 5) In the criteria box under key from the 2nd table, put >[tablename].[key1] 6) Sort on key1 of the first instance of the table. 7) run the query You should get a list of duplicate keys with the first instance plus all the other instances. You can delete dups using the counter key = key1 ========================================================================= Date: Wed, 18 Aug 1993 16:56:46 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Bill Stewart Subject: Re: DBMS Magazines I'm currently receiving a magazine from the Pinncle group that is dedicated to Access. It also comes with a disk. I think the 12 month subscription was around $75.00. I like it because it talks about the inner working of Access. They have quite a few articles that have been written by the Access development team. Let me know if you want more info ------------------------------------------------------ Bill Stewart Gendale Community College 6000 W. Olive Ave Glendale AZ. 85302 ------------------------------------------------------ ========================================================================= Date: Thu, 19 Aug 1993 06:15:25 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: DBMS Magazines In-Reply-To: <9308181627.AA16129@rampage.psi.net> >DATE: Wed, 18 Aug 1993 11:10:55 -0500 >FROM: John Daum at 6-6835 or 618-632-2456 > >Does anyone have a recommendation for a good, well rounded magazine for >databases? The perfect one would cover the popular PC DBs (Paradox, Major general ones are Data Base Advisor and DBMS. The former has more tips and techniques. Both are available on almost all newsstands. John King ========================================================================= Date: Thu, 19 Aug 1993 08:16:12 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Eugene Levine Subject: InfoWorld Reviews In-Reply-To: <199308191051.AA12072@world.std.com> For those who haven't seen it, the current issue of InfoWorld compares 4 programmable Windows databases (Access, Fox, Paradox and SuperBase). For those who don't like the tester's conclusions, there's a nice Microsoft advertisement just opposite the article :-) Gene Levine elevine@world.std.com ========================================================================= Date: Thu, 19 Aug 1993 15:55:22 BST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Simon Mercer Subject: Search/Replace bug Hi all, In my job, I collect data from about fifty other databases, and put it into my own (access) database. Having collected some records, I have to clean th em up, so I use the search/replace dialogs frequently. I notice that in the 1.1 version of access, there is no way to search and replace the character ?, because it is also a wildcard. I have tried searching for [?] (which works in 1.0), but no luck. The MS support guy said this was a bug, so I thought I would let you know about it. Simon Mercer (simon@bioch.ox.ac.uk) ========================================================================= Date: Thu, 19 Aug 1993 10:46:14 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Duplicate record checking in Access $ From: Karen McMains, INTERNET:uis!mcmains@HENSON.CC.WWU.EDU $ Our Admissions Office hopes to use Access for our simple, but quite large, $ name-and-address database of prospective students. We receive students' $ names from multiple sources (phone calls, letters inquiring about our $ school, college fairs, students who send us SAT/ACT scores, etc.). In $ most cases we do not get their SSN, and so we have no unique identifier. (quick interjection: I wouldn't count on SSN as a unique identifier, no matter what -- legally, SSN cannot be used as an identifer -- read your card) $ We're still using 'sneaker-net', so we must keep the central database on $ one PC, enter records to diskette using many different PCs, then import the $ daily entries to the central database at the end of each day and check for $ duplicate records. Since we have no unique identifier we use the student's $ name plus address and/or birthdate, depending on what data we have on that $ student. $ Can anyone suggest a workaround in Access? Alternately, can anyone $ suggest databases that would meet our needs for dup checking? We like $ most other features of Access and need to use the Windows environment. (I moved your final paragraph up here since it went well with the first one) I did some thinking on this whilst taking a break from trying to write a "new" C++ outline. I applied a little lateral thinking. (bear /c me, I'm in a strange mood and thinking out loud) You need a unique identifier for every potential contact (whether that contact is you reaching them or them reaching you), even if the contact is someone you already know about -- as you've found, once you have the information, it's far easier to delete duplicate information than gather what's missing. Rather than find a way for all PCs to cooperate and generate a universal identifier, why not let each PC generate an identifer you know probably won't be generated by any other? You can mix and match either of these schemes: [o] Assign a unique identifier to each PC/User/whatever and let that be the prefix to a key which would consist of the prefix + a counter value. The drawback to this is you would have to ensure each PC had a unique qualifier. Much better, but funkier, is: [o] Assign the date/time (or even just time, but make it as detailed, even to the second, as you can) stamp + a counter value as the key value. What are the odds two PC will generate the same identifier (in this format) exactly the same? This would mean two PCs would have to have the same counter number at exactly the same second. Probably not very likely. Two people on different PCs could try and coordinate their efforts and try to break it, but they'd have to work at it for awhile. It's simple, easy to generate, and really doesn't have any overhead. I don't know what your (business) political climate is, but hopefully you won't have to try to sell someone on schemes like this, despite the fact they do work. There seems to be a Promethean flaw in human nature which makes us want to put useful data in a key field, as if that will help the human using the information (that's what the computer is for!) (and if I can stay up here on my soapbox for a moment) Unfortunately, the people who propogate the need for such things are the ones who will fight tooth 'n nail to implement them against any form of reasoned protest only to see them fail. Much better to just start assigning values than to try to make them meaningful -- the computer doesn't care how meaningful they are and if you're going to look them up, why short-circuit your true efforts? I can cite many, many real-world examples where things like this have failed. $ Of course, students often give us slightly different versions of their $ names and addresses, i.e. Susie Smith, Susan Smith, S. Smith, which makes $ duplicate checking even more challenging. Since we mail thousands of $ recruiting pieces to these students, we must check for duplicates to reduce $ costs. If we could only convince direct mailing services responsible for junk mail to do the same thing -- any chance you could convince them to trade budgets with you? :{) $ We have been using PCFile5.01 for this database (groan!), and duplicate $ checking was about the ONLY part of the application that worked well $ under PCFile. Dup checking was a specific function and we could specify $ the fields, say, last name and the first three letters of the first name. $ Then PCFile would display the 'duplicates' side by side and prompt for $ which record, if any, we wished to delete. Seeing the records displayed $ side by side made it easy to determine if 'Susie Smith' was the same $ person as 'Susan Smith'. This sounds like a real labour of love! (the part about PCFile 5.01) $ We don't have access to programmers, and my sophomore MIS student and $ myself have been unable to find a good solution to dup checking with Access, $ even after calls to Microsoft. Currently she's set up a duplicate check $ using the July 1993 Smart Access tips, with the queries working on last $ name concatenated with first name, but this will miss many duplicates $ because first names won't always match, and there's no easy way to see $ which records Access is designating as duplicates. This isn't a cure-all, but you could do something similar to my address book (which is a souped-up version of the one which comes with Access): I have a firstname, lastname, etc. etc. series of fields plus a "call me" field which is how they want to be addressed. If you have information on a prospective student who filled out her standardized test under her legal name of "Susan" but likes to be called "Susie", this affords one extra field for matching: If LegalName1 = LegalName2 or CallMe1 = LegalName2 or or or or Anyways, just some food for thought. P.S. Since you are always trying to trim down your list but keep it relevant, do you keep a "last contact" field? That might help on mailings ("here's a list of people we haven't contacted or been contacted by in over a year") as well as maybe an archive or something so you could pare your active list periodically. Phil Paxton Development Editor SAMS/Prentice Hall Computer Publishing Carmel, Indiana ========================================================================= Date: Thu, 19 Aug 1993 13:11:41 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Scott Dahne Subject: Re[2]: DBMS Magazines I've seen the magazine. Pretty good stuff. Scott Dahne ______________________________ Reply Separator _________________________________ Subject: Re: DBMS Magazines Author: Microsoft Access Database Discussion List at INTERNET Date: 08/19/93 01:09 PM I'm currently receiving a magazine from the Pinncle group that is dedicated to Access. It also comes with a disk. I think the 12 month subscription was around $75.00. I like it because it talks about the inner working of Access. They have quite a few articles that have been written by the Access development team. Let me know if you want more info ------------------------------------------------------ Bill Stewart Gendale Community College 6000 W. Olive Ave Glendale AZ. 85302 ------------------------------------------------------ ========================================================================= Date: Thu, 19 Aug 1993 13:14:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: MKRO Subject: Pop-up Calender in Access Has anyone tried to provide a Pop-up Calender in an ACCESS application? I am looking for a "Spiffy" solution to providing a user with the ability to pop up a graphical calender which defaults to a specified date, and allows them to view a month at a time. This would give them the ability to realize when weekends and holidays may conflict with a shipping date. They would then be able to pick a date and that date be entered into a field on a ACCESS table(shipping day) and the popup calendar disappear. I have considered picking apart the calendar from the "CMS" application on the MS ACCESS companion diskett, but that seems to tedious and does not look to impresive. Is there someway to pass information to and from an existing Windows app like the Calendar, through an API call? Any suggestions? ========================================================================= Date: Thu, 19 Aug 1993 14:29:55 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Pop-up Calender in Access In-Reply-To: Message of Thu, 19 Aug 1993 13:14:00 LCL from You can call the Windows Calendar applet with a macro...try a RunApp command pointing to Calendar. Sendkeys Keystrokes: {F9} Wait: No RunApp Command Line: Calendar This starts the Calendar and puts it into the Month mode (rather than the daily appointment mode, which it defaults to without the SendKeys statement). Tie that macro to a command button and you've got a pop-up calendar. HTH -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 19 Aug 1993 14:35:34 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Pop-up Calender in Access In-Reply-To: Message of Thu, 19 Aug 1993 13:14:00 LCL from Sorry, wasn't paying attention...whether or not you can pull in the date is another matter. You might take a look at the AppActivate statement in the Language Reference--it calls the Calculator, performs some calculations, and then displays the result. That might give you some clues. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 19 Aug 1993 15:36:52 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Pop-up Calender in Access % I have considered picking apart the calendar from the "CMS" application on % the MS ACCESS companion diskett, but that seems to tedious and does not look % to impresive. % Is there someway to pass information to and from an existing Windows app like % the Calendar, through % an API call? % Any suggestions? I'd suggest just writing one -- not that difficult, especially since the day of week routines are built-in (and even if they weren't I could supply you with some of the shortest DOW, julian<->gregorian, etc. code you've probably ever seen) I remember getting bored years ago and writing calendars in low-level spreadsheets -- it should be pretty easy with all of the tools provided... ========================================================================= Date: Thu, 19 Aug 1993 15:38:37 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Shameless Plug enclosed I debated plugging something I've worked on and decided the benefit to the reading audience was more important than other things. Besides, I did put a warning on the subject. "Access 1.1 Developer's Guide" by Roger Jennings (SAMS/Prentice Hall Computer Publishing) (ISBN 0-672-30178-4) should begin appearing on the shelves within the next few days. This book is by a developer for developers. It does not attempt to teach Access but addresses problems, solutions, methodologies, and issues concerning those persons who wish to develop solid, polished applications, whether it be for personal use or for distribution (so obviously ADK issues are dealt with). Anyone who has developed an application for use by others knows how difficult it can be simply because when you run your (own) applications, you already know how to use it -- you don't have to worry about lots of little things users seem to unravel for you. Those issues are the foundation of this book. At $39.95 for nearly 1200 pages, you won't find yourself skipping the first section or half because you already know Access -- the entire book is of benefit to the development community! (whether it be how to write wizards, solid ABC, ODBC, help files, etc.) As a former longtime systems programmer and consultant, the highest praise I can pay this book is "if I didn't work here, I'd buy it." Phillip Paxton Development Editor SAMS/Prentice Hall Computer Publishing CARmel, Indiana (carMEL is in California) ========================================================================= Date: Thu, 19 Aug 1993 15:16:52 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Shameless Plug enclosed In-Reply-To: Message of Thu, 19 Aug 1993 15:38:37 EDT from <72410.2162@COMPUSER VE.COM> Phil, judge that plug to be OK. The list is here for the exchange of information, including info on current books. If it was a blind post from someone off the list, I'd say otherwise. A gentle plug of something you've worked on that happens to a commercial product when you are a contributing member of the list is another story. You know the product and are offering your information in the form of a review. Works for me... Out-and-out solicitation to purchase is definitely against BITNET/CREN guidelines, however. (Not aimed at Phil, just making the general observation for the good of the cause...) Sounds like an interesting book! I will give it a look. Always patronize your local publishers, I say...:) -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 19 Aug 1993 13:24:23 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Re: Shameless Plug enclosed In-Reply-To: <9308192018.AA10172@hermes.intel.com>; from "Phil Paxton" at Aug 19, 93 3:38 pm > I debated plugging something I've worked on and decided the benefit to the > reading audience > was more important than other things. Besides, I did put a warning on the > subject. I would agree that the benefit outweighs any other ethical problems. Thank you for posting about the book. Questions: 1. Any chance Microsoft will be selling the book? I understand they resell a number of books written for their products. I think we get a discount from MS, which is why I ask. 2. What is the fastest way to get the book otherwise? Can you tell I'm excited about it? Sounds like just what we've been asking for. Thanks again. -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Fri, 20 Aug 1993 14:13:00 +01 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Nilsson Jimmy, HK/R IDE" Subject: Replication of databases Hi! ---- I have a problem (which I think is pretty usual). I want to make it possible to use a database in the same way as you can use Lotus Notes, but I want to make it with an Access database. The functionality I want is the replication of data so that many people can work with the same database without having to beeing online all the time. Do You know anybody who has solved this problem? Is there any product to buy? Please help me! --Regards ----Jimmy Nilsson --------University of Karlskrona/Ronneby, Sweden ### ========================================================================= Date: Fri, 20 Aug 1993 10:26:02 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Scott Dahne Subject: Access vs. Visual Basic 3.0 Does anyone have any feelings on the use of Access versus Visual basic 3.0 now that VB has the Access engine embedded? ========================================================================= Date: Fri, 20 Aug 1993 10:38:35 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Access vs. Visual Basic 3.0 % Does anyone have any feelings on the use of Access versus Visual basic % 3.0 now that VB has the Access engine embedded? Well, the VB3.0 docs aren't very definitive about this or OLE 2.0 support -- I do know of a couple of solutions in the works... ;{) Phil Paxton Development Editor SAMS/Prentice Hall Computer Publishing Carmel, Indiana ========================================================================= Date: Fri, 20 Aug 1993 19:38:26 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jeffrey Young I am a new user of Access and have a couple questions that are probably pretty basic, but are driving me bonkers. I have created a table, and a query of that table, and a form of that query. I use the form to input data to the source table with some fields using the pull-down menu features. I would like to have selected fields displayed in the form to "carry" the value from the previous form as their default value. I know I can pull in this data manually if I enter Cntrl-" at these fields. But doing that for every field I want to carry data to is a real pain, not to mention rather awkward for the user. I have used Aston Tate's dBase IV and you can assign this carry function as a field attribute in the FORM design. Can Access do the same somehow? Also I would like to have those fields that are DATE format, and that do not have a value yet defined in them, to have today's date assigned to this field if they are clicked on or selected somehow. Is this possible? Thanks in advance for the help! jeff young jyoung@banyan.com ========================================================================= Date: Sat, 21 Aug 1993 14:10:38 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Scott Dahne Subject: Re: No subject given To carry fields: create a text box on the second from with the source as =forms![form name]![control] where form name is the name of the first form and control is the name of the field on that first form containing the variable you want to pass. Scott Dahne sdahne@lmi.org ______________________________ Reply Separator _________________________________ Subject: No subject given Author: Microsoft Access Database Discussion List at INTERNET Date: 08/20/93 07:44 PM I am a new user of Access and have a couple questions that are probably pretty basic, but are driving me bonkers. I have created a table, and a query of that table, and a form of that query. I use the form to input data to the source table with some fields using the pull-down menu features. I would like to have selected fields displayed in the form to "carry" the value from the previous form as their default value. I know I can pull in this data manually if I enter Cntrl-" at these fields. But doing that for every field I want to carry data to is a real pain, not to mention rather awkward for the user. I have used Aston Tate's dBase IV and you can assign this carry function as a field attribute in the FORM design. Can Access do the same somehow? Also I would like to have those fields that are DATE format, and that do not have a value yet defined in them, to have today's date assigned to this field if they are clicked on or selected somehow. Is this possible? Thanks in advance for the help! jeff young jyoung@banyan.com ========================================================================= Date: Sat, 21 Aug 1993 22:14:15 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Greg Fairnak Organization: The American University Subject: Re: Pop-up Calender in Access In-Reply-To: Message of Thu, 19 Aug 1993 13:14:00 LCL from Pop up calender???? Maybe get a copy of scheduler (MS) and use DDE. Check developers CD ROM or technet for free copy. I think the NT CDROM release has the source for applettes(calendar) on the disk G ========================================================================= Date: Sat, 21 Aug 1993 22:23:20 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Greg Fairnak Organization: The American University Subject: Re: Access vs. Visual Basic 3.0 In-Reply-To: Message of Fri, 20 Aug 1993 10:26:02 EST from Faster to develop apps and produce reports using Access. Some VBers seem to dislike crystal reports. You could say access is more data aware. G ========================================================================= Date: Sat, 21 Aug 1993 21:41:32 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Access vs. Visual Basic 3.0 In-Reply-To: Message of Sat, 21 Aug 1993 22:23:20 EDT from Access is a more data aware than VB. VB is also missing some key elements of the Access engine (at least in my opinion)--particularly the FindRecord method (as opposed to FindFirst, FindNext, etc.) which allows you to match case, search as formatted, and search all fields just by specifying the proper options. It happens that I need that functionality for an app I'm writing and it just isn't there in VB. I dislike Crystal Reports immensely. This is mostly because it uses its own syntax for record selection instead of MS SQL, which would be a better choice considering that the Access engine already accepts the SQL syntax. I wrote that on my Crystal Reports registration form when I sent it in. The other thing I dislike about Crystal Reports that I just discovered today is that it does not support automatic formatting of dot matrix mailing label formats (unless I'm missing something). The flip side is that it's functional and beats the heck out of trying to format reports in code. It's just not as easy to use as the Access report engine. (And I never thought I'd say anything nice about the Access report engine, either, other than the fact that it beats the heck out of the dBase way of doing things.) At $199 list for the VB 3.0 upgrade for MS Access registered users, I felt (and feel) that it was more cost effective for me to purchase VB rather than the ADK to develop stand-alone Access applications. If MS would get that FindRecord method installed and do something toward making Access-developed reports out of the .MDB visible to VB, it would be an nice package. (BTW, I can't get VB to pull queries out of the .MDB, either, unless I specify the query name by typing it into the RecordSource property setting of the data control. Queries, unlike tables, do not show up in the pull- down list box. Why??????) There are some quirks in VB that Access users will be uncomfortable with at first. As noted, the controls are by and large not data-aware. I have coped with the problem of option groups not being data-aware by tying them to hidden text boxes on the form and executing code in click events to change the underlying data. There may be other ways of doing this but this was the workaround I discovered. Another thing that bothers me is that the property window doesn't stay on top. I get extremely tired of popping it back up every time I jump back into the form to highlight a different control. It is extremely clear to me that two different development teams were at work on the two different products--it is not a seamless transition as I think I led myself to believe. :) VB is extremely versatile and I hope to use it a lot to develop stand- alone products. I will continue to do the bulk of my MAJOR database development in Access. It's a case of picking the right tool for the job, and I would not be likely to use VB for a major DBMS project unless a future version were more data-aware and more Access-aware. I hope the MS folks listening in will pass this along to the VB team. At least tell them to include FindRecord next time!!!! :) Oh, one other thing--the help compiler. Everything is there except the Help Project Editor. This doesn't make much sense to me, as it means you have to code your help project files (the .hpj file that the compiler uses) by hand. I've been using the Windows Help Authoring Templates (WHAT) and the files that come with it, including WHPE.EXE, the Help Project Editor, and it makes life MUCH easier. (WHAT and HAG, the help authoring authoring guide, are both available on CICA, by the way.) It just doesn't make any sense to me that VB shipped with the Help Compiler but not the Help Project Editor. Aieee...well, maybe that's why my name isn't Bill Gates...I don't have the high level approach. :) This LONG posting got out of hand on a list that should be focused on Access. I've been bad...please excuse. I should know better, right? :) Oh, BTW, there a Visual Basic list if anyone is interested--it's VISBAS-L@TAMVM1.BITNET. It's EXTREMELY active...daily digests have been running 1000-1500 lines. Enjoy... -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Sun, 22 Aug 1993 06:59:31 -0600 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: richard dixon Subject: Re: Access vs. Visual Basic 3.0 In-Reply-To: Thanks to Nathan and everyone for the Access vs. VB 3.0 thread (among other things). It was (is) very informative. I raised these questions on my initial mailing to the list and am gratified to learn more about the distinctions between the two products. I am still perplexed by the fact that The Kit is needed to distribute Access but VB is royalty-free out of the box. Essentially, if the two are used to create a single app, a third (the Kit) is still needed for distribution, even though VB distribution is royalty-free. Anyone have any ideas why VB would be free and Access would need the kit? What is MS thinking? Will The Kit need to be upgraded as MS makes major upgrades to Access? Just curious. Thanks, Richard ========================================================================= Date: Sun, 22 Aug 1993 10:36:47 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Access vs. Visual Basic 3.0 In-Reply-To: Message of Sun, 22 Aug 1993 06:59:31 -0600 from Just as a wild fling in the dark...DBMS compilers that produce stand-alone programs have always been insanely expensive (going back to what I know about dBase--seems to me that the runtime compiler for dBase IV 1.0 listed somewhere between $450 and $600), while straight language compilers such as QuickBasic, QuickC, and the Borland products (I think) have always included the royalty-free distribution biz. I do NOT know why this is, excepting only the thought that Ashton-Tate (now Borland), for instance, was more interested in people buying the whole shebang (dBase in any of its myriad versions) and paying the insanely high price for THAT rather than essentially saying, go ahead, develop cheap database stand-alones and we'll just sit back and smile while we lose our shirts. In VB or Access, everyone can be a programmer. This is not necessarily true of dBase...but if you dBase, and use the Assist menu, you can do most things without writing a line of code. On the other hand, if this is a marketing strategy aimed at having millions of copies of dBase IV in the hands of people who won't even scratch the surface of what it's capable of, why is the list price so damn high????? As to why Microsoft has abandoned its long-time royalty-free attitude and NOT included a compiler with Access, I have absolutely no idea... but I can't afford both VB and the ADK and I need VB for other reasons. Result: MS can scratch one ADK sale until the price comes down or they wake up and include the compiler with Access at the same price. (BTW, now that the introductory period is over, have you the list price on Access 1.1? Yow!) I would point to the same "argument" I think A-T/Borland uses to justify making a developer's kit optional and as much or more expensive than the DBMS product itself...but then I wonder who the split personality was who decided a royalty-free runtime Access engine (somewhat crippled, as I detailed earlier, but still an Access engine) should come included with VB 3.0 but separately (with full functionality) and at a steep price for Access itself. Don't get me wrong--I'd LOVE to have a copy of the ADK. One thing I neglected to mention in my last post as a weakness (in my view) in VB 3.0--as a VB/DOS 1.0 user, I use the ISAM files created with the PROISAMD TSR. Why doesn't Access recognize this format (and as a corollary, why doesn't VB 3.0 recognize this format)? It would be awfully nice to be able to use that data in both environments without having to convert the ISAM to a comma-delimited or tab-delimited format first. I was mightily surprised and disappointed when Access 1.0 flatly dismissed the ISAM format (and imports Btrieve, dBase, Fox, etc., of which I use only dBase). And ANOTHER thing...why doesn't MS just INCLUDE the ISAM commands in the interpreter in both the PDS and VB/DOS? That TSR is a pain in the ... well, you know. :) Maybe I'm missing something...I don't know. Maybe Access 2.0 will have a compiler like VB????? (And no Crystal Reports???) :) There are many issues here that are barely related to Access and again I apologize...but it would be nice if the development teams at MS talked to each other and tried to find ways for their applications to live with one another. Windows itself has provided much of this sort of functionality, OLE has done the same, but down at the gut level we're talking about, data formats should have something in common (or at least, the various products should know about each other's special formats). *30* for now. I encourage folks to jump in with this sort of give-and-take so long as no one writes me complaining about it. I think cross-platform information sharing in this crazy DBMS world is important and that's one of the reasons this list is here. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 23 Aug 1993 10:04:12 +0100 Reply-To: focke@gmd.de Sender: Microsoft Access Database Discussion List Comments: Warning -- original Sender: tag was Stefan.Focke@GMD.DE From: Stefan Focke Subject: How to change a query a form is based on? Hello! I would like to change a query a form is based on while the form is active. That is what I have: - I have a form with a button and a subform - The subform is based on a query "myquery" - With the button I activate a Access Basic program that uses DeleteQueryDef and CreateQueryDef to change the query "myquery" My problem: - The only way to activate the changed query is to close the form and open it again. - I would like to have something Requery that rereads the Query Thank you Stefan Focke ---------------------------------------------------------------------- Stefan Focke Tel. 02241-14-3154 GMD-ISA e-mail: focke@gmd.de Rathausalle 10 D-W 5205 Sankt Augustin 1 ********** MS-Word: From the guys who brought us EDLIN ******** ========================================================================= Date: Mon, 23 Aug 1993 10:21:27 +0100 Reply-To: focke@gmd.de Sender: Microsoft Access Database Discussion List Comments: Warning -- original Sender: tag was Stefan.Focke@GMD.DE From: Stefan Focke Subject: Access Animation Screen Hello! How to start the Access animation screen: - Create a new database - Create a table with one row - Save it as Cirrus - Select Help|Info - Press - Doubleclick the key-symbol with the right mouse button - now it starts - speed it up by clicking with the left mouse-button This works with the german version 1.1. Maybe it also works for you. Stefan ---------------------------------------------------------------------- Stefan Focke Tel. 02241-14-3154 GMD-ISA e-mail: focke@gmd.de Rathausalle 10 D-W 5205 Sankt Augustin 1 ********** MS-Word: From the guys who brought us EDLIN ******** ========================================================================= Date: Mon, 23 Aug 1993 06:00:52 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Morris Myers Subject: Re: Access vs. Visual Basic 3.0 > > ... and disappointed when Access 1.0 flatly > dismissed the ISAM format (and imports Btrieve, dBase, Fox, etc., of which > I use only dBase). I was equally disappointed that MS did not choose to use the Paradox 4.0 database format as one of the types that they would import. It makes it difficult for us bilingual folks to use Access with existing Paradox 4.0 applications. (A whole new market could open for MS! {:->). > > ...I don't know. Maybe Access 2.0 will have > a compiler like VB????? (And no Crystal Reports???) :) > I'll vote for that kind of improvement!! > There are many issues here that are barely related to Access and again > I apologize Please don't apologize for expressing such good ideas. After all, isn't a list like this for exchange of ideas! :-)... Those ideas don't have to be just technical or problematic. > ...but it would be nice if the development teams at MS > talked to each other and tried to find ways for their applications > to live with one another. Alas, a problem shared by TOO many PC development houses. MS talks like they pride themselves on their inter-project communications but it looks like they missed a bit with Access and VB 3.0. Thanks for the thoughts, nathan ... g.mo -- ----------------------------------------------------------------------- Morris Myers [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-746-4798 Bldg. M3 Room 311 Fax: 408-629-4374 1230 E. Arques Avenue Email: xrysta@mcode.amdahl.com Sunnyvale, CA 94088-3470 or: morris@xrysta.birdsong.suvl.ca.us ========================================================================= Date: Mon, 23 Aug 1993 09:11:01 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Re: Access Animation Screen > Hello! > > How to start the Access animation screen: > > - Create a new database > - Create a table with one row > - Save it as Cirrus > - Select Help|Info > - Press > - Doubleclick the key-symbol with the right mouse button > - now it starts > > - speed it up by clicking with the left mouse-button > > > This works with the german version 1.1. Maybe it also works for you. Works great with the US version as well. Not one of the more exciting animations I've seen, though. So, what is the significance of the two ducks being destroyed? Usually such an animation is some sort of sneaky reference to the competition, such as with the animation screen in Microsoft Word, where there is a reference to WordPerfect. Any clues? -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Mon, 23 Aug 1993 13:16:00 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Skewes-Cox, Tom" Subject: Re: Access Animation Screen | > How to start the Access animation screen: | > | > - Create a new database | > - Create a table with one row | > - Save it as Cirrus | > - Select Help|Info | > - Press | > - Doubleclick the key-symbol with the right mouse button | > - now it starts | > | > - speed it up by clicking with the left mouse-button | > | > | > This works with the german version 1.1. Maybe it also works for you. | | Works great with the US version as well. Not one of the more exciting | animations I've seen, though. So, what is the significance of the two | ducks being destroyed? Usually such an animation is some sort of sneaky | reference to the competition, such as with the animation screen in | Microsoft Word, where there is a reference to WordPerfect. Any clues? | | -- Destroying a "Pair of ducks" Sneaky enough I think ;) ========================================================================= Date: Mon, 23 Aug 1993 16:38:02 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Access Animation Screen % | Works great with the US version as well. Not one of the more exciting % | animations I've seen, though. So, what is the significance of the two % | ducks being destroyed? Usually such an animation is some sort of sneaky % | reference to the competition, such as with the animation screen in % | Microsoft Word, where there is a reference to WordPerfect. Any clues? % | % | -- % Destroying a "Pair of ducks" Sneaky enough I think ;) Even more sneaky than you think. What do you think the icon was during the Paradox beta? Phil Paxton Development Editor SAMS/Prentice Hall Computer Publishing Carmel, Indiana ========================================================================= Date: Tue, 24 Aug 1993 07:40:00 +01 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Nilsson Jimmy, HK/R IDE" Subject: SV: Re: Replication of databases Do you have any ideas on your own? Perhaps you are interested in making an objekt-oriented model together with me? That would be a good start I think. Then I hope some other would like to help too. C U Jimmy Nilsson, University of Karlskrona/Ronneby, Sweden Jimmy.Nilsson@ide.hk-r.se ### ---------- Fran: owner-visbas-l Till: Multiple recipients of list VISBAS-L Angaende: Re: Replication of databases Datum: fredag 20 augusti 1993 12.43 I just asked a question like this to the foxpro list. no responses yet. ========================================================================= Date: Tue, 24 Aug 1993 08:30:03 CDT Reply-To: tntow@timtow.b1.ingr.com Sender: Microsoft Access Database Discussion List From: Tim Tow Subject: NetDDE with Access as a Server Has anyone successfully used NetDDE with Access as a server? I have an Excel app that uses DDE with the "SQL" topic to run dynamically prepared SQL statements (that return a boolean, ie is an account number valid..)... I would like to migrate this to a network environment but have not had success... I think I have defined the DDE Shares correctly and actually get a channel number, however, when I try to retrieve the data, I get an error which seems to indicate the channel number is invalid. If anyone has done this successfully, please contact me via email.. I will post a summary to this list... Thanks.. ---------------------------------------------------------------------------- Tim Tow, CPA Phone: 205-730-8234 Intergraph Corporation Fax: 205-730-2164 Mailstop: HQ011 Mailpath: tntow@ingr.com Huntsville, AL 35894-0001 ========================================================================= Date: Tue, 24 Aug 1993 11:04:42 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Steve Bratten Subject: Hidden animation in MS programs... Thanks for the information on accessing the animation in Access. Now, I have two brief questions: 1) Is the primary difference between the standard and professional versions of Visual Basic the ability to distribute applications without royalties? 2) How do we see the animation in MS Word (2.0c)? ^^^^^^^^^Steve Bratten^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | _ o__ | | ( \ _/_ _.>/^_ BITNET < GE0793@SIUCVMB > | | \ / _ _ _ (_) \(_) INTERNET < GE0793@SIUCVMB.SIU.EDU > | | \_) (__(/_/(_/\_(/_ | | __ \o \o \o Graduate School | | |__) __ __ -/-/-_ __ |> |> |> Southern Illinois University | | |__) / (_(_/(_/`/_(/_/// < \ < \ < \ Carbondale, IL 62901-4716 | | | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^ ========================================================================= Date: Tue, 24 Aug 1993 13:42:15 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Hidden animation in MS programs... %Thanks for the information on accessing the animation in Access. Now, I %have two brief questions: I'm surprised there was anyone left who hadn't seen it...BTW, those are usually called "Easter Eggs" % 2) How do we see the animation in MS Word (2.0c)? "Feed a man a fish, he's full today, teach a man to fish, he's full forever." (Chinese Proverb) Extract the following code and send it to LISTSERV@UIUCVMD.CSO.UIUC.EDU You'll get the answer to your question and many other Easter Egg questions... -------------------------------------------------------------------------------- ---------- //Looking JOB Echo=YES,Reply-via=MAIL Database search DD=Mine //Mine DD * Search EASTER EGG in WIN3-L index PRINT ALL -------------------------------------------------------------------------------- ---------- ========================================================================= Date: Tue, 24 Aug 1993 13:07:44 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jon Diercks Subject: Re: Access Animation Screen In-Reply-To: from "Skewes-Cox, Tom" at Aug 23, 93 1:16 pm Did you all happen to notice the very last name in the "Special Thanks To" section? It's a name we should all be familiar with! -- \on \ jon@anderson.edu Administrative Systems \_\ <_\iercks Anderson University > Anderson, IN --- ...Life is too important to be taken seriously. ========================================================================= Date: Tue, 24 Aug 1993 13:33:20 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Access Animation Screen In-Reply-To: Message of Tue, 24 Aug 1993 13:07:44 EST from Well shucks. I guess I'm just going to have to get off my duff and send my $20 to MS for Access 1.1. You guys are having all the fun! :) -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Tue, 24 Aug 1993 13:38:52 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jon Diercks Subject: Re: Access Animation Screen In-Reply-To: from "Nathan Brindle" at Aug 24, 93 1:33 pm > Well shucks. I guess I'm just going to have to get off my duff and > send my $20 to MS for Access 1.1. You guys are having all the fun! ... the animation screen works in 1.0 too. try it! -- \on \ jon@anderson.edu Administrative Systems \_\ <_\iercks Anderson University > Anderson, IN --- ...Life is too important to be taken seriously. ========================================================================= Date: Tue, 24 Aug 1993 17:02:12 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Access Animation Screen In-Reply-To: Message of Tue, 24 Aug 1993 13:38:52 EST from Hmm ... I did. It didn't work. Maybe I did something wrong. I'll try it again! Thanks! :) -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Tue, 24 Aug 1993 23:37:44 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phillip Paxton <72410.2162@COMPUSERVE.COM> Subject: Algorithms Because of so many requests, I'm reprinting the algorithms for Day of Week, Julian->Gregorian, and Gregorian->Julian, as well as a Leap Year function which returns an integer value depending upon whether the specified year is a Leap Year. Remember, a Leap Year is any year not ending in 00 divisible by four, or any century (ending in 00) year which is divisible by 400. This means 1800 and 1900 are not Leap Years, but 2000 is. The mathematics are all mine, derived from before I ever had access to a calculator, let alone a computer (mostly from going to grad school with my mum when I was ten or eleven and needing something to do when they were taking their tests). Whilst discovered independently, my DOW routine is very, very similar to Zoeller's congruence, but I didn't know that when I put the numbers together. There is also an alternative method which derives the same numbers, but is easier to do as a bar trick (long story). The source is REXX, so if you aren't familiar with REXX, it should still be readable and portable to other programming platforms, but you should know that the percent sign (%) represents integer division and double slash (//) represents the modulo function (aka remainder for those who failed mathematics). I'm offering these for your enjoyment. These are protected from commercial exploitation via print copyright (a real one, not fiat) so I'm requesting [that] if you use them in a commercial endeavour, you mention who gave it to you. Just remember, I can prove I understand the math, so if you betray me, you may be pressed upon to do the same! (be forewarned -- I'm Evariste Galois reincarnated!!!) I also carry algorithms for Easter and basedate (from Computer Language magazine), non-recursive: repeating permutations, non-repeating permutations, combinations (far easier than many you'll see in magazines), wind chill, relative humidity, computing roots of any degree by an alternative, averaging method, and a method of computing prime factors which isn't in print anywhere else yet, but has been confirmed as practical, as well as tips about doing things like GCF and LCD. Enjoy. Phillip Paxton Development Editor SAMS/Prentice Hall Computer Publishing Carmel, Indiana ------------------------------------------------------------------------ ------------------------------------------------------------------------ Alternative Method for day-of-week computations: Last Two Digits of the Year: 93 Divide by Four (ignore remainder): 23 Add Day of Month: 24 Month Offset (see below): 3 ------------------------------------------- Total (add): 143 Divide by 7 20 Remainder: 3 Sun=1, Mon=2, Tue=3, Wed=4, Thu=5, Fri=6, Sat=0 August 24, 1993 is a Tuesday. Month Codes: Jan=1 Apr=0 Jul=0 Oct=1 Feb=4 May=2 Aug=3 Nov=4 Mar=4 Jun=5 Sep=6 Dec=6 During Leap Years, use Jan=0, and Feb=3. ------------------------------------------------------------------------ /* DOW (Day of Week) Routine */ /* Source: original algorithm by Phillip Paxton */ arg month day year . weekday.0 = 'Sunday'; weekday.1 = 'Monday'; weekday.2 = 'Tuesday'; weekday.3 = 'Wednesday'; weekday.4 = 'Thursday'; weekday.5 = 'Friday'; weekday.6 = 'Saturday'; call leapyr year; leapyear = result; /* get leapyear value */ ld = year // 100; /* get the last two digits of the year */ m1 = (month + 9) // 12 + 1; /* make jan 11, feb 12, mar 1, apr 2, ... */ m2 = m1 // 11; m2 = trunc( 0.8 * ( 2 * m2 + 1 ) + m2 ); /* month offset to jan 1 */ m2 = m2 - ( leapyear * ( m1 % 11 ) ); /* correct for leapyear */ w = ( ld + ld%4 + day + m2 ) // 7; /* determine day of the week */ say month'/'day'/'year 'is/was/will be a' weekday.w; exit; ------------------------------------------------------------------------ /* JULIAN Routine (convert Gregorian to Julian) */ arg month day year . call leapyr year; leapyear = result /* determine leap year value */ jul = trunc( (month + 2) * 30.55 ) + day - 91 if ( jul > 60 ) then jul = jul - 2 + leapyear; say 'The Julian date for' month'/'day'/'year 'is' jul'.'year ------------------------------------------------------------------------ /* GREGORIAN routine (convert julian to gregorian) */ /* Source: original algorithm by Phillip Paxton */ arg jul year .; day = jul; call leapyr year; leapyear = result; /* determine leapyear value */ if ( day > ( 59 + leapyear ) ) then day = day + 2 - leapyear; day = day + 91; month = day % 30.55; day = day - trunc(month * 30.55); month = month - 2; say 'The Gregorian date for' jul'/'year 'is' month'/'day'/'year; ----------------------------------------------------------------------- /* LEAPYR EXEC - is it a leap year? 1=yes; 0=no */ /* will handle 2 or 4 digit year; assumes current century if 2 digit */ arg year; cc = year % 100; if cc = 0 then cc = substr( date(SORTED), 1, 2 ); yy = year // 100; /* last 2 digits year */ if yy % 4 ^= 0 then leap = 0; else do; if ( (yy = 0) & (cc % 4 = 0 ) ) | ( yy ^= 0) then leap = 1; else leap = 0; end; /* else */ return( leap ); ----------------------------------------------------------------------- ========================================================================= Date: Wed, 25 Aug 1993 14:20:25 +0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: NCLCHAN@NTUVAX.BITNET Subject: Attach Oracle table I tried to attach Oracle table to Microsoft Access datafile file in Microsoft Access 1.1. I noticed that once I attached the Oracle tables ( after closing Attach Table Dialog Box ), I no longer could attach any Oracle tables. Error Message - ODBC Call fails. Has anyone out there ever encountered something like that ? How do you solve the problem ? By the way, I know that I can attach the Oracle tables if I quit Microsoft Windo ws and go in again. But tedious , isn't it ? Chor Ling NCLCHAN@NTUVAX.NTU.AC.SG ========================================================================= Date: Wed, 25 Aug 1993 14:24:09 +0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: NCLCHAN@NTUVAX.BITNET Subject: Editing Attached Oracle Table Has anyone out there edited attached Oracle Table in Microsoft Access 1.1. ?? I tried to edit but the attached Oracle Table is read-only. Any advice ? Chor LIng NCLCHAN@NTUVAX.NTU.AC.SG ========================================================================= Date: Wed, 25 Aug 1993 16:22:14 +0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: NCLCHAN@NTUVAX.BITNET Subject: Re: Attaching Oracle Table I have solved the problem. I tried to attach in another PC and it works. I guess Oracle doesn't like my PC ;-). Anyway, please forget my Question. Chor Ling ========================================================================= Date: Wed, 25 Aug 1993 16:23:24 +0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: NCLCHAN@NTUVAX.BITNET Subject: Re: Editing Oracle Table I solved the problem by creating a primary key. Please forget my Question. Chor Ling ========================================================================= Date: Wed, 25 Aug 1993 11:02:58 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Scott Dahne Subject: Output of job "Easter Egg Hunt" I received the following message: --------------------------------------------------------------------------- Subject: Output of your job "Looking" Author: BITNET list server at UIUCVMD (1.7f) Date: 08/25/93 10:45 AM Job "Looking" started on 25 Aug 1993 09:07:39 Job "Looking" ended on 25 Aug 1993 09:07:39 Summary of resource utilization ------------------------------- CPU time: 0.001 sec Device I/O: 0 Overhead CPU: 0.002 sec Paging I/O: 0 CPU model: 3081 DASD model: 3380 ---------------------------------------------------------------------------- when trying to get the easter eggs using a message that looked like: //Looking JOB Echo=YES,Reply-via=MAIL Database search DD=Mine //Mine DD * Search EASTER EGG in WIN3-L index PRINT ALL Any ideas on what happened? Scott Dahne sdahne@lmi.org ========================================================================= Date: Wed, 25 Aug 1993 09:55:24 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Chet Farmer Organization: Project IDEALS -- The University of Alabama Subject: Automatic field updates In-Reply-To: Message of Wed, 25 Aug 1993 16:23:24 +0800 from I've a question, and I'm hoping somebody can help out. I have a largish database of names and addresses (just under 2k records). For convenience's sake, I include a field for both Country AND Country-in- French. I also include a field for the country telephone code (eg, 44 for England). My question is this. Is there an easy way to have the French-country and country-code fields filled automatically in the primary table/data entry form given an entry in the regular-country field AND another table with each country's corresponding French name and telephone code? For example: I enter John Doe into the database. When I get to the Country field, I enter "Japan," since that's where he lives. Access should, in the best of all possible worlds, then look in Table 2 for the entry for Japan, which holds (in named fields, of course) the French name and the telephone code. Access places these bits of data into the appropriate fields in the original table so I don't have to do it, and Bob's your uncle. I've experimented with the DLookUp function to a point; I've even managed to get a non-interactive version of this working for the French name (ie, I've an action query that runs through the database and supplies the French name for every record). What I want still eludes me. Ideas? The *real* kicker is that ultimately my boss would like this to work very smoothly -- ie, as soon as you type enough of the english name for a country to uniquely identify it in the database, it finishes the name AND fills the other two fields. I don't know how practical that is, but it's a goal. I've got to get this working the regular way first, though. Thanks in advance. +----------------------------------------------------------------+ | Chet Farmer, Assistant Director | tel 205-348-9494 | | Project IDEALS | cfarmer1@ua1vm.ua.edu | | The University of Alabama | chet.farmer@genie.geis.com | |----------------------------------------------------------------| | C is for Cookie, and that's good enough for me. -- C. M. | +----------------------------------------------------------------+ ========================================================================= Date: Wed, 25 Aug 1993 08:12:13 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Clyde F. Bingham III" Subject: Re: Output of job "Easter Egg Hunt" In-Reply-To: Message of Wed, 25 Aug 1993 11:02:58 EST from I copied this command from a letter to the ACCESS list which said you could get information on hidden ACCESS screens using it. Well, I guess it didn't work. I gave up on it and don't intend to send it again. Thanks. ========================================================================= Date: Wed, 25 Aug 1993 10:33:49 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Steve Bratten Subject: What version of VB do I need... Does the standard version of Visual Basic provide access to the Access file structure? What are the main differences between the standard and professional versions? Sorry if these are old questions but I need to know. :-) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | o__ | | Steve Bratten _.>/^_ BITNET < GE0793@SIUCVMB > | | Graduate School (_) \(_) INTERNET < GE0793@SIUCVMB.SIU.EDU > | | Southern Illinois University | | Carbondale IL 62901-4716 \o \o \o Graduate School | | Voice: (618) 453-4552 |> |> |> Southern Illinois University | | Fax: (618) 453-4562 < \ < \ < \ Carbondale, IL 62901-4716 | | | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^ ========================================================================= Date: Wed, 25 Aug 1993 11:52:38 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: What version of VB do I need... In-Reply-To: Message of Wed, 25 Aug 1993 10:33:49 -0500 from On Wed, 25 Aug 1993 10:33:49 -0500 Steve Bratten said: >Does the standard version of Visual Basic provide access to the Access >file structure? > >What are the main differences between the standard and professional >versions? > >Sorry if these are old questions but I need to know. :-) > The Data control is available in both versions. Methods available ONLY in the PROFESSIONAL edition are: Table Methods: AddNew, Clone, Close, CreateDynaset, CreateSnapshot, Delete, Edit, FindFirst, FindLast, FindNext, FindPrevious, ListFields, ListIndexes, MoveFirst, MoveLast, MoveNext, MovePrevious, Seek, Update...in other words, ALL of the Table methods in VB 3.0 are only available in the Pro edition. Dynaset Methods: Clone, ListFields, ListIndexes only in Pro edition. Snapshot Methods: Clone, Close, FindFirst, FindLast, FindNext, FindPrevious, ListFields, ListIndexes, MoveFirst, MoveLast, MoveNext, MovePrevious...as with Table methods, ALL of the Snapshot methods are ONLY available in the Pro edition. Most of the Dynaset methods available in the Standard Edition, viz.: AddNew, Close, Delete, Edit, FindFirst, FindLast, FindNext, FindPrevious, MoveFirst, MoveLast, MoveMext, MovePrevious, Update. As you can no doubt see, the Professional edition for $100 more (if you have the upgrade offer for registered users of Access) may be well worth the price if you want the added functionality. The above is from page 16 of the VB 3.0 language reference. I'm going to harp on the ONE method that I WISH MS would have included in the Access Engine for VB: FINDRECORD!!!!!!!!!! Also check the archives for this list...at some point a month or so ago I posted the professional edition-specific added attractions from the VB brochure. HTH, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 25 Aug 1993 13:03:56 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Output of job "Easter Egg Hunt" % I received the following message: % % --------------------------------------------------------------------------- % Subject: Output of your job "Looking" % Author: BITNET list server at UIUCVMD (1.7f) % Any ideas on what happened? % Scott Dahne Not offhand. I just tried a few minutes ago and received a 76K file, which is about what I've expected. I haven't checked to see if anything new has appeared, but like most other cyclic topics, Easter Eggs make their rounds on the WIN3-L regularly by those discovering them for the first time. I know the file works as that's my standard LISTSERV template (all you have to do is change the keywords and the list you're looking in). BTW, you usually get two sets of files when performing LISTSERV commands via a file like that: one with the "console log", the other with the results. Phil Paxton Development Editor SAMS/Prentice Hall Computer Publishing CARmel, Indiana ========================================================================= Date: Wed, 25 Aug 1993 12:16:52 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Output of job "Easter Egg Hunt" In-Reply-To: Message of Wed, 25 Aug 1993 13:03:56 EDT from <72410.2162@COMPUSER VE.COM> Yes, as Phil pointed out, you're going to get two responses from the listserver--one, like you reposted to the list, that only summarizes the job and tells you what happened, and the other, the actual data returned to you. On a VM machine, this will likely come as a Netdata file and won't show up as mail (although it show up in your reader). You type RECEIVE at the command prompt to get it out of the reader and onto your disk. In VAX/VMS, there is another set of commands used to receive a file that are distinct from MAIL or PMDF. Not being a VAX user except when forced :), I don't know what they are. Chances are, the file got sent to you and you just aren't aware of it. Also note that file transfers are slower than mail most of the time...the file may still be in transit. AND if you're on AOL, you're out of luck on file transfers in the first place. Sorry. That's an AOL thing, not Internet. HTH, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 25 Aug 1993 13:18:24 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Harry Yeatts Subject: combos and concatenations Hello Accessers: I've got a bit of a puzzle I'm hoping someone out there can shed some light on. In the detail section of a report, I have two controls: [author] =[title]&" "&"("&[year]&")" which gives: Deighton, Len Violent Ward (93) This works PERFECTLY on its own. However, when I use a macro to open the report and filter the [author] records...all hell breaks loose: I get an MSACCESS error message with two choices: close or ignore. Then I get an APPLICATION ERROR message citing a General Protection Fault with msaccess.exe. The macro that opens the report has: OpenReport SelectObject ApplyFilter The "where" argument under ApplyFilter: [author]=Forms![which author? form]![author pick list] The [author pick list] is a combo box on a form used specifically to allow the user to pick a particular author. This works fine too *IF* I don't have the above concatenation on the form, and just have [title] and [year] separate. So I'm between a rock and a hard place on this one. Any ideas? I'll be glad to furnish more particulars... Harry Harry Yeatts (HYEATTS) INTERNET: VTVM1.CC.VT.EDU Virginia Tech BITNET: VTVM1 Blacksburg, Virginia PHONE: 703-231-5141 Notes: (1) I left [author] out of the expression on the report because I wanted to hide duplicates. (2) I didn't use |bars| in the concatenation in the report expression because they don't work. (Even on-line help doesn't use them.) (3) I'm using Access 1.1 ========================================================================= Date: Wed, 25 Aug 1993 13:40:53 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Amy C. Park" Subject: Easter Egg Search... I'm having trouble with the Easter Egg Hunt, too! :-) Received: from VMD.CSO.UIUC.EDU by UCONNVM.UCONN.EDU (Mailer R2.08 R208004) This is the message I have been getting - is there a problem with that database or something? HELP! Any more brilliant ideas? VMD.CSO.UIUC.EDU (LMail V1.1d/1.7f) with BSMTP id 8850; Wed, 25 Aug 1993 12:40:00 -0500 %Date: Wed, 25 Aug 1993 12:40:00 -0500 %From: BITNET list server at UIUCVMD (1.7f) %Subject: File: "DATABASE OUTPUT" %To: SBALAB2%UCONNVM.bitnet@VMD.CSO.UIUC.EDU %> Search EASTER EGG in WIN3-L %--> Error: Database WIN3-L does not exist. Database removed from search list. %--> No hit. % %> index %--> No hit in previous search, nothing to list. % %> PRINT ALL %--> No hit in previous search, nothing to print. ========================================================================= Date: Wed, 25 Aug 1993 16:24:03 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Greg Fairnak Organization: The American University Subject: VIRUS ALERT For those of you who use VB 3.0 pro and Visual control pack for C++ the file termset.frm is infected with the shake virus. I find that most anti virus programs cannot locate it. I thought you folks on the list should know. Regards, Greg ========================================================================= Date: Wed, 25 Aug 1993 14:03:47 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Dmitry Serebrennikov Subject: Re: Out of Memory when changing Datatype Sorry, in my present setup I can't quote, so... In the original post the problem is that there is out of memory message during chaniging a fild datatype in the table design view. I had that happen too. The possible solution is to create a second field with a different name of the desired datatype and run an update query that will copy the values from one field to another (doing nessosory conversions on the go). Then you'll be able to just delete the first field and rename the second to the needed name. Now you may still run into the problems with memory (not enough memory to undo, etc.) but at least you'll be able to finish. If you are still out of memory -- try doing the query piece by piece (i.e. use a criteria like [ID] < 2000, assuming ID is like record number). I know it's a pain, but I don't know a better solution... dmitry@ucsee.berkeley.edu ========================================================================= Date: Wed, 25 Aug 1993 14:21:19 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Tim King Subject: Re: VIRUS ALERT In-Reply-To: <9308252031.AA12163@relay1.UU.NET> from "Greg Fairnak" at Aug 25, 93 04:24:03 pm Thus spake Greg Fairnak: > For those of you who use VB 3.0 pro and Visual control pack for C++ > the file termset.frm is infected with the shake virus. I find that most > anti virus programs cannot locate it. I thought you folks on the list should > know. How do you know this? What do we DO about it? -- Tim King, tcking@uswnvg.com US West NewVector Group Inc., Bellevue, Washington ========================================================================= Date: Wed, 25 Aug 1993 18:22:49 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: ? Because there has been so much dedicated to the crossover for VB3 & Access, I'm curious: is there any interest in a book which would be written at the developer level for persons wanting to develop databases using VB3, but crossing over to Excel, Access, etc., perhaps even dabbling in the forthcoming Visual Basic for Applications (aka Object Basic) ??? Let me hear your voice! Phil Paxton Development Editor SAMS/Prentice Hall Computer Publishing Carmel, Indiana ========================================================================= Date: Wed, 25 Aug 1993 17:32:59 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: VIRUS ALERT In-Reply-To: Message of Wed, 25 Aug 1993 16:24:03 EDT from Greg, can you give us some specifics, like which virus programs detect it, where you heard about it, etc? Thanks, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 25 Aug 1993 17:35:01 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: ? In-Reply-To: Message of Wed, 25 Aug 1993 18:22:49 EDT from <72410.2162@COMPUSER VE.COM> Phil, count my vote as "yes" on the proposed cross-platform book. Sounds like a good idea to me! -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 26 Aug 1993 12:22:00 GMT+1200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Daniel Bar-Even Organization: National Library of New Zealand Subject: Checking for relational integrity Help! I've got two tables imported from a paradox database with integrity problems. They are joined on a key field (Clientno). There should not be a record without a corresponding record in the other table. What is the easiest way to find those records? On other systems I would've written an SQL statement like: Select * from table1 where clientid not in (Select clientid from table2) Can't seem to do anything like this in Access TIA ********************************************************** Daniel Bar-Even (daniel.bar-even@baxter.natlib.govt.nz) Client Support Analyst National Library of New Zealand Te Puna Matauranga o Aotearoa P.O. Box 1467 Wellington New Zealand Ph: (04) 474-3000 Fax: (04) 474-3161 ********************************************************** ========================================================================= Date: Wed, 25 Aug 1993 20:38:53 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: George Raudabaugh Subject: Re: Checking for relational integrity Use an outer join: Join table1.clientid to table2.clientid. Double click on the join line. Select option 2. Add a restriction of Is Null to table2.clientid. I haven't tried this, but it should work. If it isn't exactly correct, see the doc on outer joins. George -- George Raudabaugh Manager/Document Technologies Information Dimensions, Inc. raudabaugh@idi.oclc.org (work email) 5080 Tuttle Crossing Blvd. Dublin, Ohio 43017 (614) 761-7309 (voice mail) ========================================================================= Date: Wed, 25 Aug 1993 20:14:25 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Tim King Subject: Re: ? In-Reply-To: <9308252231.AA10476@relay1.UU.NET> from "Phil Paxton" at Aug 25, 93 06:22:49 pm Thus spake Phil Paxton: > > Because there has been so much dedicated to the crossover for VB3 & Access, > I'm > curious: is there any interest in a book which would be written at the > developer level > for persons wanting to develop databases using VB3, but crossing over to > Excel, > Access, etc., perhaps even dabbling in the forthcoming Visual Basic for > Applications > (aka Object Basic) What *I* really need is an advanced book that focuses on database development in VB 3.0 using the Access engine. The VB 3.0 books I've seen on the market so far devote just a few pages to the basics of the data control. One book (I won't say whose name is on the cover, but his initials are Peter Norton) makes no mention at all of the database capabilities; doesn't even show the data control in pictures of the toolbox. -- Tim King, tcking@uswnvg.com US West NewVector Group Inc., Bellevue, Washington ========================================================================= Date: Thu, 26 Aug 1993 07:52:00 +01 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Nilsson Jimmy, HK/R IDE" Subject: Faster startup with ADK? Is there anyone who know if the startup of an Access ADK-application goes any faster than it does to start the usual Access? If so, how big is the difference? The reason for my question is that it really takes some time to start Access on a network! Jimmy Nilsson University of Karlskrona/Ronneby, Sweden Jimmy.Nilsson@ide.hk-r.se ========================================================================= Date: Thu, 26 Aug 1993 05:46:54 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Morris Myers Subject: Re: ? Phil, I would consider buying a book that provided cross-over development guidance and examples. -- ----------------------------------------------------------------------- Morris Myers [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-746-4798 Bldg. M3 Room 311 Fax: 408-629-4374 1230 E. Arques Avenue Email: xrysta@mcode.amdahl.com Sunnyvale, CA 94088-3470 or: morris@xrysta.birdsong.suvl.ca.us ========================================================================= Date: Thu, 26 Aug 1993 08:51:20 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: CHARLES FRANKLIN Organization: Southwest Texas State University Subject: Re: VisualBASIC Development Book >Because there has been so much dedicated to the crossover for VB3 & Access, >I'm curious: is there any interest in a book which would be written at the >developer level for persons wanting to develop databases using VB3, but >crossing over to Excel, Access, etc., perhaps even dabbling in the forthcoming >Visual Basic for Applications (aka Object Basic) We're just now getting into some client/server development perhaps using VisualBasic and/or Visual C++. We'd be very interested in a development book that talks about these products interfacing with standard Windows software (Word, Excel, Access, etc) also OLE and DDE. It would also be of benefit if it would also have a chapter on SQL access to mainframe databases (Rdb in particular, but others would be a benefit as well)- perhaps working with EDA/SQL or someother middleware as examples. Sounds more like a three volume reference set :-) Charles Franklin Southwest Texas State University Information System and Services cf03@admin.swt.edu (512) 245-2271 ========================================================================= Date: Thu, 26 Aug 1993 09:58:04 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Greg Fairnak Organization: The American University Subject: virus stuff Guys, Do you ever feel like you are chasing a ghost? I have two brand new systems which I have installed MS Dos, VB, Win and other MS programs. The computer began to exhibit virus like behavior aka SHAKE. Now, CPAV and MSAV did not detect it. I also use an AES adaptive expert system anti virus program which tells me that it thinks that this file termset.frm has a virus. Now this could be a false negative, because the file is in text ASCII format. Now on the one hand I have a brand new damaged computer from a virus type problem. On the other hand, my virus is contained in an acsii(? :-{ ) file. Now I called MS to tell them about what I found. This type of stuff usually involves shooting the messenger. You told us, so it is your fault. My only intention is to alert developers about the potential of the problem. Now, I would keep that file on a separate floppy for a while. I will continue to test these files and see if I can find the problem. Now maybe I win the award for hole in the foot, shooting my gun while it is still in the holster. :-) Although I will continue testing until I find the problem. I hope that I am wrong, but I still have the infected brand new machine. Thanks for your time, Greg ========================================================================= Date: Thu, 26 Aug 1993 10:25:42 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Greg Fairnak Organization: The American University Subject: no virus Okay, I .frm file has the word Shake in it many times. This set off the AES. The culprit was a 1226 virus which hopped on top of MSAV and then infected the floppy drives. My apologies to the people at MS for mentioning this potential problem. Although this does tell me that MSAV does not have any anti piggybacking protection. Back to our regularly scheduled program. G ========================================================================= Date: Thu, 26 Aug 1993 08:13:49 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Re: no virus In-Reply-To: <9308261437.AA24557@hermes.intel.com>; from "Greg Fairnak" at Aug 26, 93 10:25 am > Okay, > I .frm file has the word Shake in it many times. This set off the > AES. The culprit was a 1226 virus which hopped on top of MSAV and then > infected the floppy drives. My apologies to the people at MS for mentioning > this potential problem. Although this does tell me that MSAV does not have > any anti piggybacking protection. > > Back to our regularly scheduled program. Pardon, but I am sure I am not alone here in knowing _nothing_ about viruses beyond the ability to scan for them at regular intervals. First, what is this Shake virus? Next, what is a 1226 virus? Finally, please be a bit more explanative when discussing this stuff. We don't all read comp.virus ya know. Oh yes. Don't know what "the AES" is either. -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Thu, 26 Aug 1993 14:34:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: DAVID FARR Subject: Checking for relational integrity The Microsoft FastTips Fax service, 206-635-7051, has a document #95326 that may help. 'For example, say you have two tables, joined on a common field (customer ID). Your goal is to find the records in Table1 that do not have a matching customer ID in table2.' Dave Farr ========================================================================= Date: Thu, 26 Aug 1993 06:18:24 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: ? In-Reply-To: <9308252231.AA00954@rampage.psi.net> >DATE: Wed, 25 Aug 1993 18:22:49 EDT >FROM: Phil Paxton <72410.2162@COMPUSERVE.COM> > >curious: is there any interest in a book which would be written at the >developer level >for persons wanting to develop databases using VB3, but crossing over to >Excel, >Access, etc., perhaps even dabbling in the forthcoming Visual Basic for >Applications >(aka Object Basic) > I would be interested in such a book. Currently, I am involved in developing an application in Access, with hooks into Word. I have thought of using VB 3.0 to develop some conversion routines for new releases, etc. It all seems to be tying together. "Seamlessly" is a cliche, but that is what users want. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Thu, 26 Aug 1993 17:08:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: mkro Subject: Printing Directly to a printer Hello!! Have anyone out there done any printing using Access basic? I have an Access application that needs to print AIRBORN shipping labels on an AIRBORN supplied form that is 4" high and 7 1/4" wide. The information on the airbill will come from various tables within the database. These forms are 3 layers carbonated, so an impact printer is required. Has anyone coded print statements directly to a printer port? Is anyone trying to do something similar? Anyone have any design suggestions? Also, is anyone implementing any BARCODE input/output solutions in their Access App? Regards, Mike Kroeger *** uuencoded BINARY enclosure *** The section below this line contains an MHS attachment. To extract it, copy this message to a file and use the program UUDECODE. For information on using UUDECODE on UNIX systems, type the command 'man uudecode'. The attachment name was originally: ATTRIBS.BND --------------- begin 644 attribs.bnd M0F5Y;VYD(%!A8VME9"!!='1R:6)U=&5S``;_&VIK*```````4')I;G1I;F<@ M1&ER96-T;'D@=&\@82!P'1P`DAE;&QO(2$@(`H@ M(`H@("!(879E(&%N>6]N92!O=70@=&AE6]N92!C;V1E9"!P`0$` MWP$"`@$``P(#`@$`!`)-`@$`3@)9`@$`6@):`@$`6P)C`@$`9`)P`@$`<0)Q M`@```````````````&0``7@``?```6@!`>`!`5@"`=`"`4@#`<`#`3@$`;`$ M`2@%`:`%`1@&`9`&```````````````0``8````````````````````````` 8``!!='1A8VAM96YT($-O=6YT!``````` ` end ========================================================================= Date: Fri, 27 Aug 1993 10:14:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: RH Subject: Suppressing the Access sign-on screen Hello! Does anyone know how to suppress the sign-on screen that says: Microsoft Access Version 1.1 Copyright... Thanks in advance, Bob Hanschke Texas Instruments, Inc. Dallas, TX Regards, Bob Hanschke MSGID RH Office (214) 917-6393 Fax (214) 917-1505 ========================================================================= Date: Thu, 26 Aug 1993 21:57:58 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Richard Moldwin Subject: Re: VIRUS ALERT In-Reply-To: Your message of Wed, 25 Aug 1993 16:24:03 EDT Well, How do we get rid of the shake virus if we can't detect it. Please tell us more! ========================================================================= Date: Fri, 27 Aug 1993 14:04:53 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Global variable problem I have a global variable, declared as such in a module's declarations section. My problem is, some AccessBasic functions seem to recognize it fine, and others do not. In other words, sometimes when I need to know the value in this variable, it is there, and in other functions, it is empty. Is there something I should know about global variables in Access? -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Fri, 27 Aug 1993 09:11:00 +0100 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List Comments: Sent using PMDF-822 , routing is done by ECNICE From: Bart Schaap Subject: security of Access database Hello out there, I am using version 1.0 of Access and I think I've found a serious security problem. In a networked environment, use of an Access database is controlled by means of a system.mda file which must be located on a disk where all potential users have read/write permission. Security info for a database is stored there and if a user uses this file, security is not a problem. However ALL SECURITY IS LOST if someone uses such a database while using his own (local) system.mda file. Our network software is DEC PCSA version 4.1. Is this still the same in version 1.1? Is there a solution for this problem? Thanks, Bart. ========================================================================= Date: Fri, 27 Aug 1993 20:19:00 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: George Raudabaugh Subject: Re: Checking for relational integrity I got confirmation that my posted recommendation about this problem worked. So instead of using the FAX service below, just be open about responding to other questions that come across on the list. If your company requires spending money on free information, please send email about how I want the check made out ;). George -- George Raudabaugh Manager/Document Technologies Information Dimensions, Inc. raudabaugh@idi.oclc.org (work email) 5080 Tuttle Crossing Blvd. Dublin, Ohio 43017 (614) 761-7309 (voice mail) >From: IN%"ACCESS-L%INDYCMS.BITNET@uga.cc.uga.edu" "Microsoft Access Database D iscussion List" 27-AUG-1993 17:38:39.91 >To: IN%"ACCESS-L%INDYCMS.BITNET@uga.cc.uga.edu" "Multiple recipients of list A CCESS-L" >CC: >Subj: Checking for relational integrity > >The Microsoft FastTips Fax service, 206-635-7051, has a document >#95326 that may help. 'For example, say you have two tables, joined on >a common field (customer ID). Your goal is to find the records in >Table1 that do not have a matching customer ID in table2.' > >Dave Farr ========================================================================= Date: Mon, 30 Aug 1993 16:15:01 GMT+1200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Daniel Bar-Even Organization: National Library of New Zealand Subject: Sorting Criteria Does anybody know how I can get a query or a report to sort by a field specified in a form? I have a form called ReportCriteria which I use to select records for a report. I can select a field from a field list in the form but I don't know how to use that sort on. I though that I'd to be able to say something like "ORDER BY Forms!ReportCriteria!SortByField" in my query. Unfortunately that doesn't have any effect. ========================================================================= Date: Mon, 30 Aug 1993 08:48:24 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jack Marshall Subject: Accessing Table's Field I would like to be able to invoke a function from the ValidateRule that would set another field [LastModDate] in the same table. At first glance I thought [LastModDate] = NOW would work, but the function apparently doesn't know what table to use. I then tried things like [mytablename]![LastModDate] = NOW, also without success. As I got more intense I thought of things like setting a pointer to the CurrentDB, but even this way I couldn't find a way to point to the "CurrentTbl". I was able to make the function work against a form by using FORM![mytablename]![LastModDate] = NOW - surely there is a way to do the same thing from the table's spreadsheet view. I would sure like to understand this issue - please send any advice directly to me since I'm no longer a memeber of the list (maybe I should be!) +------------------------------+---------------------------+ | Jack Marshall | (612) 482-4408 (voice) | | Control Data Systems, Inc. | (612) 482-4417 (fax) | | 4201 Lexington Ave. N. | | | Arden Hills, MN 55126-6198 | Jack.Marshall@cdc.com | +------------------------------+---------------------------+ ========================================================================= Date: Mon, 30 Aug 1993 12:59:41 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Re: Suppressing the Access sign-on screen % Does anyone know how to suppress the sign-on screen that says: % % Microsoft Access Version 1.1 % % Copyright... Just out of curiosity, what makes this a sign-on screen? BTW, it's normally called a "splash screen" ========================================================================= Date: Mon, 30 Aug 1993 11:33:09 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: johnvon@HALCYON.COM Subject: Re: Sorting Criteria In-Reply-To: <199308301812.AA08372@halcyon.com> from "Daniel Bar-Even" at Aug 30, 93 04:15:01 pm > > Does anybody know how I can get a query or a report to sort by a > field specified in a form? > > I have a form called ReportCriteria which I use to select records for > a report. I can select a field from a field list in the form but I > don't know how to use that sort on. > > I though that I'd to be able to say something like "ORDER BY > Forms!ReportCriteria!SortByField" in my query. Unfortunately that > doesn't have any effect. > You have to concatenate the variable into the query string. Build the query using the query builder, putting in a sort for one of the fields. Run the query to make sure it works. Go into view SQL, highlight all of the SQL, and use CTRL-C to copy it to the clipboard. In Access BASIC, you will need to rebuild the query. You then need to assign a variable to you SQL and make a querydef out of it. Your code will look something like: SQLString = "Select * from foo order by '" & Forms!ReportCriteria!SortByField & "' with owneraccess option" You next need to use the OpenQueryDef method to open your query, the set it's SQL property to the above string (customized for you!), close the query, and run the report based on the query. When you test, make sure your SortByField has a value, or put a trap for zero length strings in your code. Good luck. John " ========================================================================= Date: Mon, 30 Aug 1993 14:50:40 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: Sorting Criteria In-Reply-To: Message of Mon, 30 Aug 1993 16:15:01 GMT+1200 from I'd also like to know the answer to Daniel Bar-Evans's question aboiut sorting. Thanks, David Crookall ========================================================================= Date: Mon, 30 Aug 1993 14:57:58 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: Sorting Criteria In-Reply-To: Message of Mon, 30 Aug 1993 11:33:09 -0700 from Oups, sorry, that was a quick reply about sorting thanks, david ========================================================================= Date: Mon, 30 Aug 1993 15:00:37 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List Comments: Resent-From: CROOKALL@UA1VM Comments: Originally-From: Chet Farmer From: David Crookall Organization: Project IDEALS -- The University of Alabama Subject: Automatic field updates In-Reply-To: Message of Wed, 25 Aug 1993 16:23:24 +0800 from Hwoever, I do have another question. I'd be most grateful for a reply. I have a largish database of names and addresses (just under 2k records). For convenience's sake, I include a field for both Country AND Country-in- French. I also include a field for the country telephone code (eg, 44 for England). My question is this. Is there an easy way to have the French-country and country-code fields filled automatically in the primary table/data entry form given an entry in the regular-country field AND another table with each country's corresponding French name and telephone code? For example: I enter John Doe into the database. When I get to the Country field, I enter "Japan," since that's where he lives. Access should, in the best of all possible worlds, then look in Table 2 for the entry for Japan, which holds (in named fields, of course) the French name and the telephone code. Access places these bits of data into the appropriate fields in the original table so I don't have to do it, and Bob's your uncle. I've experimented with the DLookUp function to a point; I've even managed to get a non-interactive version of this working for the French name (ie, I've an action query that runs through the database and supplies the French name for every record). What I want still eludes me. Ideas? The *real* kicker is that ultimately my boss would like this to work very smoothly -- ie, as soon as you type enough of the english name for a country to uniquely identify it in the database, it finishes the name AND fills the other two fields. I don't know how practical that is, but it's a goal. I've got to get this working the regular way first, though. Thanks in advance. +----------------------------------------------------------------+ | Chet Farmer, Assistant Director | tel 205-348-9494 | | Project IDEALS | cfarmer1@ua1vm.ua.edu | | The University of Alabama | chet.farmer@genie.geis.com | |----------------------------------------------------------------| | C is for Cookie, and that's good enough for me. -- C. M. | +----------------------------------------------------------------+ ========================================================================= Date: Mon, 30 Aug 1993 13:35:29 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Report groupings Decided that this might be eaiser to ask of the list than Microsoft, because of the visual nature: When grouping data in reports, Access tends to groups things like: XXXXX YYYYYY ZZZZZ ZZZZZZZZ ZZZZZ ZZZZZ ZZZZZZZZ ZZZZZ ZZZZZ ZZZZZZZZ ZZZZZ YYYYYY ZZZZZ ZZZZZZZZ ZZZZZ ZZZZZ ZZZZZZZZ ZZZZZ ZZZZZ ZZZZZZZZ ZZZZZ Instead, I would like to group as follows: XXXXX YYYYYY ZZZZZ ZZZZZZZZ ZZZZZ ZZZZZ ZZZZZZZZ ZZZZZ ZZZZZ ZZZZZZZZ ZZZZZ YYYYYY ZZZZZ ZZZZZZZZ ZZZZZ ZZZZZ ZZZZZZZZ ZZZZZ ZZZZZ ZZZZZZZZ ZZZZZ The difference is that I want the group headings to be in-line with the rest of the data. Is it possible to do this in Access, or am I just missing something obvious? -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Mon, 30 Aug 1993 17:51:40 PST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jon D Gardner Subject: Re: Suppressing the Access sign-on screen Starting Access with a "/s" parameter will bypass the splash screen. Set the Command line to: C:\ACCESS\MSACCESS.EXE /s int Program Manager's Program Item Properties dialog box. Jon Gardner Intel SQL Server Program Folsom, CA (916) 356-2664 -------------------------------------------------------------- >Hello! > >Does anyone know how to suppress the sign-on screen that says: > > Microsoft Access Version 1.1 > > Copyright... > > > >Thanks in advance, >Bob Hanschke >Texas Instruments, Inc. >Dallas, TX > >Regards, >Bob Hanschke MSGID RH Office (214) 917-6393 Fax (214) 917-1505 ========================================================================= Date: Tue, 31 Aug 1993 09:19:04 +0800 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: NCLCHAN@NTUVAX.BITNET Subject: Maximize the form before opening form Does anyone know how to maximize the form before the form is opened ? Normally Macro - openform & then maximize. It is so UGLY to see the "small" form being enlarge when you execute the macro. Is there a way to see the maximized form on the screen once you execute the macr o ? Chor Ling NCLCHAN@NTUVAX.NTU.AC.SG ========================================================================= Date: Tue, 31 Aug 1993 09:29:20 +0200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Stefan Focke Subject: Re: Accessing Table's Field >I would like to be able to invoke a function from the ValidateRule >that would set another field [LastModDate] in the same table. At first >glance I thought [LastModDate] = NOW would work, but the function >apparently doesn't know what table to use. I then tried things like >[mytablename]![LastModDate] = NOW, also without success. As I got more >intense I thought of things like setting a pointer to the CurrentDB, >but even this way I couldn't find a way to point to the "CurrentTbl". >I was able to make the function work against a form by using >FORM![mytablename]![LastModDate] = NOW - surely there is a way to do >the same thing from the table's spreadsheet view. I think, that it is not possible because you are only allowed to write a expression as a validation rule. If you want to update another field you need a macro or Access Basic program assigned to a field in a form. Stefan ---------------------------------------------------------------------- Stefan Focke Tel. 02241-14-3154 GMD-ISA e-mail: focke@gmd.de Rathausalle 10 D-W 5205 Sankt Augustin 1 ********** MS-Word: From the guys who brought us EDLIN ******** ========================================================================= Date: Tue, 31 Aug 1993 09:32:12 +0200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Stefan Focke Subject: Re: Automatic field updates >I've experimented with the DLookUp function to a point; I've even managed >to get a non-interactive version of this working for the French name (ie, >I've an action query that runs through the database and supplies the >French name for every record). What I want still eludes me. DLookUp should work for you. I did something simular and it worked. Prehaps you should post the code you use. Stefan ---------------------------------------------------------------------- Stefan Focke Tel. 02241-14-3154 GMD-ISA e-mail: focke@gmd.de Rathausalle 10 D-W 5205 Sankt Augustin 1 ********** MS-Word: From the guys who brought us EDLIN ******** ========================================================================= Date: Tue, 31 Aug 1993 09:06:49 BST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Anne L Zorner R27.G5/" Subject: re security SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB =============================================================== I posted some information in the last 3 months about Access Security. Basically the text in the manual does not tell the whole story. To get hold of the whole story get hold of the Access Security White Paper which is stored ( I think at CICA) Nathan put it it up somewhere cant remember exactly where. Anyway in brief the hey is to not create the tables owned by ADMIN but rather some user. Access 1.1 is different however I have not yet checked it for loopholes and no one else has cpmmented on it. Anne Thankyou =============================================================== ========================================================================= Date: Tue, 31 Aug 1993 13:40:52 +0200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Slawomir Zadrozny Organization: Research and Academic Computer Network Hello! I wonder if it is known how a WHERE clause condition is evaluated. From my experience I know that it is not done simply from left to right. For example in the clause: (c1 AND c2 ...) OR (... AND ... AND ) OR ... OR clas t condition "clast" may be evaluated as a first. (I hope that my description is not too unclear). Certainly it is a desirable effect of optimizatione done by Access, but I would like to know what is exact order of evaluation. Thanks for any suggestions. Slawomir Zadrozny Systems Research Institute Polish Academy of Sciences Warsaw, POLAND ========================================================================= Date: Tue, 31 Aug 1993 08:52:53 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: re security In-Reply-To: Message of Tue, 31 Aug 1993 09:06:49 BST from The White Paper is NOT on CICA--I never got around to putting it there and will try to rectify that error today or tomorrow--but it IS available from LISTSERV@INDYCMS by sending the command GET SECURE TEXT to LISTSERV@INDYCMS.BITNET or LISTSERV@INDYCMS.IUPUI.EDU. I apologize for forgetting to put the White Paper on CICA but with the students coming back and everything else the world is throwing at me :) it just plain old slipped my mind. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Tue, 31 Aug 1993 13:17:45 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: John von Colditz Subject: Re: Maximize the form before opening form In-Reply-To: <199308310140.AA28361@halcyon.com> from "NCLCHAN@NTUVAX.BITNET" at Aug 31, 93 09:19:04 am > > Does anyone know how to maximize the form before the form is opened ? > Normally Macro - openform & then maximize. > > It is so UGLY to see the "small" form being enlarge when you execute the macro. > Is there a way to see the maximized form on the screen once you execute the macr > o ? > > Chor Ling > NCLCHAN@NTUVAX.NTU.AC.SG > I've never tried it, but, you might be able to set the form's visible property to false, maximize it, and then set the visible property to true. You might also just want to store the forms with visible set to false, open them, maximize them, set the visible property to true. You probably want to set visible back to false when you close the form. John